Change Password of DPM SSRS account

Problem:

You want to change or have already changed the DPM SQL Reporting Services account password DPMR$<DPMSERVERNAME> after initial install of DPM.

Now when you try to access DPM reports you get this error:

clip_image001

An error has occurred during report processing. (rsProcessingAborted)

Cannot impersonate user for data source ‘DLS’. (rsErrorImpersonatingUser)

Log on failed. Ensure the user name and password are correct. (rsLogonFailed)

Logon failure: unknown user name or bad password

Solution:

You need to modify the DPMR$<DPMSERVERNAME> password in SSRS also.

To do this go to:

http://DPMSERVERNAME/Reports_MSDPM2012

Click on the DPM Reports folder

clip_image002

Then click on the DPMReporterDataSource object

clip_image003

Update the password for the account under "Credentials stored securely in the report server"

image

Click "Test Connection" to make sure it is working. Once confirmed click "Apply".

clip_image005

Now Reports should work again.

Print Friendly, PDF & Email

Leave a Comment