First published on TECHNET on Dec 05, 2013
~ Mike Jacquet
Hello, Mike Jacquet here, and today I’d like to discuss a problem you may encounter after installing System Center 2012 R2 Data Protection Manager from scratch or after performing an upgrade from DPM 2012 SP1.
When you attempt to schedule a report to be mailed, you receive the following popup error.
Reporting Services Server cannot connect to the DPM database.
To repair the configuration, follow steps for repairing DPM from DPM Setup Help.
Figure 1 below shows this error.
Following the repair steps suggested in the
link does not resolve the problem.
To resolve this error, please use the steps below to make proper configuration changes which will then allow DPM reports to be e-mailed.
NOTE: Some steps may not be necessary if you encounter the problem after an upgrade from DPM 2012 SP1. Review and perform the steps as applicable.
1. On the DPM 2012 R2 server, create a new
called "DPMDBReaders$<DPMServerName>" In my example the DPMServername is WINB-DPM.
2. Create a
new local user
called "DPMR$<DPMServerName> and provide a strong password that never expires. See figure 3 below.
3. Add the newly created user to the DPMDBReaders$DPMservername group that was created in step 1 above. See figure 4.
4. Start SQL Management Studio using administrative privileges and connect to the SQL instance used by DPM. Under
, right-click on the
then browse to add the local group DPMDBReaders$<DPMServerName >. Once the group is added it will be listed as seen in figure 5.
5. Right-click the group and select
Under the General section, change the default database to the DPMDB name. See figure 6.
6. Under the
section, select the checkbox for the DPMDB name and the checkbox for the
role. See figure 7.
7. In SQL Management Studio, navigate to the Databases > DPMDB > Security > Users > and select the DPMDBReaders$<DPMServerName>" group. See figure 8.
8. Right-click the DPMDBReaders$<DPMServerName>" group and select
. Under the
section, click on
. On the
dialog, click OK. On the
dialog, click the Objects type, then check the
checkbox. Browse and add the following two stored procedures:
Grant the Execute permission for both of the stored procedures added. See figure 9.
9. Exit SQL Management Studio.
Reporting Services Configuration Manager
and click on the
Web Portal URL.
See figure 10.
11. Click on the
link. This will open the http://localhost/Reports/Pages/Folder.aspx) portal as seen in Figure 11.
12. Click on the DPMReports_GUID link to open the DPM reports page as seen in Figure 12.
13. Click on the
to open its properties as seen in figure 13.
14. On the DPMReporterDataSource configuration page, perform the following steps:
Enable the option “
Using the following credentials
Type of credentials
” to “
Windows user name and password
Add the “
” user account and password created in step 2.
” to verify whether it can connect successfully.
This is what it looks like after settings are made.
15. Close the DPMReporterDataSource configuration page to return to the Reporting Services Configuration Manager screen. Click on the
. On this page change Report Server Service Account service to use
If you are prompted for the Backup Encryption Key, fill on the parameters and continue. See Figure 14 below.
16. Reboot the DPM Server to ensure all configuration changes take effect.
17. You should now be able to schedule e-mail reports without experiencing the original error.
Sorry for any inconvenience this has caused. This issue is being investigated by the Data Protection Manager product group and more information will be published as it becomes available..
Mike Jacquet | Senior Support Escalation Engineer
| Microsoft GBS Management and Security Division