DPM reporting fails (after server reinstall)

Reinstallation of DPM with the same server name and database. For instance in the case of hardware replacement. Could lead to failing reports on the DPM server.

Error

An error occurred during client rendering. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DLS'. (rsErrorOpeningConnection) Cannot open database "DPMDB" requested by the login. The login failed. Login failed for user ‘%servername%\DPMR$%servername%.

Cause
After recovery of the DPM server to new hardware. The account ‘%servername%\DPMR$%servername%. doesn’t have the correct mappings for the DPM database.

Solution

1. Connect to the MSDPM2010 instance using SQL management dtudio
2. Expand Security then expand Logins; right-click %servername%\DPMDBReaders$%servername% and select properties
3. Select User Mapping in the left pane; in the upper right pane, under "Users mapped to this login:" verify DPMDB is selected; In lower right pane, ensure db_datareader and public are both selected; click OK

An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'DPMReporterDataSource'. (rsErrorImpersonatingUser) Log on failed. Ensure the user name and password are correct. (rsLogonFailed) Logon failure: the user has not been granted the requested logon type at this computer

To resolve this error, you must ensure that the DPMReport account has the Allow log on locally user right. To assign the Allow log on locally user right to the DPMReport account: In Administrative Tools, open Local Security Policy. Under Security Settings, expand Local Policies, and then click User Rights Management. In the details pane, right-click Allow log on locally and then right-click Properties. In the Allow log on locally Properties dialog box, click Add User or Group. In the Select Users, Computers, or Groups dialog box, click Locations, click the name of the DPM server, and then click OK. In the Select Users, Computers, or Groups dialog box, enter DPMReport, and then click OK. In the Allow log on locally Properties dialog box, click OK. In the details pane, right-click Deny log on locally and then right-click Properties. If the DPMReport account is listed, select DPMReport and then click Remove