A few weeks ago I ran into a problem regarding the access to the reports that is available on a DPM server. After I did my authentication I got the the following error:
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'.
This error occurred because the users mapped to this login pointing the tha DPMDB was missing. To solve this error do this.
Open Microsoft SQL Server Management Studio and verify %DPMServerName%\MS$DPM2007$ is selected on the “Connect to Server” screen and click Connect.
Expand %DPMServerName%\MS$DPM2007$ > Security > Logins then right click %DPMServerName%\DPMDBReaders$%DPMServerName% and select Properties. On the Login Properties screen select “User Mapping” on the left pane and under “Users mapped to
this login:” verify DPMDB is selected then you will notice DPMDBReaders$%DPMServerName% will be added under the “Users” column.
Under “Database role membership for: DPMDB” verify db_datareader and public are both checked and select “OK”.