大网数据广告活动
启动与系统组件

Can't schedule an email report

· 52CE 我爱测

Describes an issue that causes the Reporting Services Server cannot connect to the DPM database error when you try to schedule a report to be emailed in Data Protection Manager.

This article helps you work around an issue where you receive the Reporting Services Server cannot connect to the DPM database error when you try to schedule a report to be emailed in Data Protection Manager (DPM).

Original product version:   System Center Data Protection Manager
Original KB number:   4457489

Symptoms

Assume that you do a new installation, or you upgrade to Microsoft System Center 2012 R2 Data Protection Manager or a later version. When you try to schedule a report to be emailed, you receive the following error message:

Reporting Services Server cannot connect to the DPM database.
To repair the configuration, follow steps for repairing DPM from DPM Setup Help.
ID: 3001

When you try the steps that are mentioned in Repair DPM, this problem isn't resolved.

Workaround

To work around this problem, follow these steps to make correct configuration changes that will enable Data Protection Manager reports to be emailed.

Note: Some steps may not be necessary if you experience this problem after you upgrade from System Center 2012 Data Protection Manager Server Pack 1. Review and do these steps as applicable.

  1. On the DPM server, create a local group that's named DPMDBReaders$<DPMServerName>. In the following example, the <DPMServerName> value is WINB-DPM.

    :::image type="content" source="media/schedule-email-report-error/new-group-window.png" alt-text="Create a new local group in the New Group window.":::

  2. Create a local user that's named DPMR$<DPMServerName>, and provide a strong password that never expires.

    :::image type="content" source="media/schedule-email-report-error/new-user-window.png" alt-text="Create a new local user in the New User window.":::

  3. Add the new local user to the DPMDBReaders$<DPMServerName> group that was created in step 1.

    :::image type="content" source="media/schedule-email-report-error/properties-window.png" alt-text="Add the new local user to the local group that you created in step 1.":::

  4. Start SQL Server Management Studio by using administrative permissions, and then connect to the SQL Server instance that's used by DPM. Under Security, right-click Logins, and then select New login > Search.... Under Object Types, select the Groups object type, and then select OK. Add the local group DPMDBReaders$<DPMServerName>, and then select OK. After the group is added, it will be listed under Logins.

    :::image type="content" source="media/schedule-email-report-error/object-explorer.png" alt-text="Select New login to add the local group.":::

  5. Right-click the new login group, and then select Properties. In the General section, change the Default database field to the DPMDB name.

    :::image type="content" source="media/schedule-email-report-error/login-properties.png" alt-text="Set the Default database field to the DPMDB name in the Login Properties window.":::

  6. Under User Mapping, select both the check box for the DPMDB name and the check box for the db_datareader role.

    :::image type="content" source="media/schedule-email-report-error/user-mapping.png" alt-text="Select the DPMDB name and the related database role membership." border="false":::

  7. In SQL Server Management Studio, navigate to Databases > DPMDB > Programmability > Stored Procedures.

  8. Right-click the following stored procedures, and then select Properties > Permissions > Search > Browse. Add the DPMDBReaders$<DPMServerName> group, grant the Execute permission, and then select OK.

    • Prc_MOM_Heartbeat_Get
    • prc_MOM_ProductionServer_Get
  9. Exit SQL Server Management Studio.

  10. Start the SQL Server Reporting Services Configuration Manager and connect to the SQL Server instance hosting the DPM reports.

  11. Select Web Portal URL, and then select the URL.

    :::image type="content" source="media/schedule-email-report-error/web-portal-url.png" alt-text="Select Web Portal URL in the Reporting Services Configuration Manager.":::

  12. Select the URLs link, as shown in step 11. This opens the https://localhost/Reports/Pages/Folder.aspx portal, as shown in the following screenshot.

    :::image type="content" source="media/schedule-email-report-error/click-url-link.png" alt-text="Select the URL link that is shown in the step 11." border="false":::

  13. Select the DPMReports_<GUID> link to open the DPM reports page, as shown in the following screenshot.

    :::image type="content" source="media/schedule-email-report-error/open-dpm-report-page.png" alt-text="Open the DPM reports page by selecting the DPMReports." border="false":::

  14. Select DPMReporterDataSource to open its properties window, as shown in the following screenshot.

    :::image type="content" source="media/schedule-email-report-error/configuration-page.png" alt-text="Select DPMReporterDataSource to open its properties window." border="false":::

  15. On the DPMReporterDataSource configuration page, follow these steps:

    1. Select the Using the following credentials option.
    2. Change the Type of credentials list selection to Windows user name and password.
    3. Add the DPMR$<DPMServerName> user account and password that you created in step 2.
    4. Select Test connection to determine whether the server can connect successfully.
    5. Select Apply.

    :::image type="content" source="media/schedule-email-report-error/credentials-window.png" alt-text="Set up credentials and test connection on the DPMReporterDataSource configuration page." border="false":::

  16. Close the DPMReporterDataSource configuration page to return to the Reporting Services Configuration Manager screen. Select Service Account. On Service Account page, change the Report Server Service Account service to use Network Service. If you're prompted for the backup encryption key, type the value, and then select Apply.

    :::image type="content" source="media/schedule-email-report-error/change-service.png" alt-text="Change the Report Server Service Account service to use Network Service in the Reporting Services Configuration Manager." border="false":::

  17. Restart the DPM server to make sure that all configuration changes take effect.

  18. Now, you can schedule email reports without experiencing the original error that's mentioned in the Symptoms section.

    :::image type="content" source="media/schedule-email-report-error/status-report-details.png" alt-text="Restart the DPM server and you now can schedule email reports.":::

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 04/08/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。