Fixing DPM 2010 Reporting Services

A useful function in DPM 2020 are the reporting capabilities.  You can generate reports to view recovery point status, disk/tape usage, etc.....

 

If the reporting function doesn't work, it may be related to the account that is used in the Reporting Services configuration.  For example, if the password you set for the reporting services account doesn't meet the local password policy, reporting functionality will fail.

 

To fix this:

• Set valid password for Reporting Services account 
Name:  DPMR$<ServerName>
 Password:  *******
• Verify account is in group:  DPMDBReaders$<ServerName>
• Go to the Reporting Services Web page: 
• http://<ServerName>/Reports_MSDPM2010/Pages/Folder.aspx
•  Click on DPMReports – DPMReporterDataSource
• In the “Connect Using” section:
• Select “Credentials stored securely in the report server”
• Enter above username and password
• Select “Use as Windows credentials when connecting…..

• Click on Apply
• Stop and start Reporting Services Instance
• Confirm the reports are functioning

 

•