Microsoft DPM 2012 R2 SMTP Reports Error

25 Feb

When configuring DPM reports I was getting the error:

reports1

reports2

Apparently this is a known a Problem in R2 if the SQL Server are local installed.

To Resolve the Problem follow the steps:

  1. Open the Report Manager URL page and Login like http://ServerName/Reports
  2. Open the Folder DPMReports_……
  3. Open the DPMReporterDataSource
  4. Change the Connect using to
    1. (x) Credentials stored securely in the Report Server, and specific a user and pw that have DPM DB Access on the SQL Server.
    2. (x) Use as Windows credentials when connecting to the data source
  5. Test connection
  6. Apply

After this you can schedule Reports in DPM 2012 R2 successfully.

reports3

reports4

reports5Update: There is a M$ guide here also: http://blogs.technet.com/b/dpm/archive/2013/12/05/attempts-to-schedule-a-mailed-report-in-dpm-2012-fail-with-reporting-services-server-cannot-connect-to-the-dpm-database.aspx