We had the following problem:

An error has occurred during report processing. (rsProcessingAborted)

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

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

Logon failure: unknown user or bad password

 

We recognized that problem after changing the password for our SCSM Service Account.

The solution was just changing in the password for the account(s) “Run As Accounts”:

image

The second thing is to other passwords at the Reportserver.

Go to http://rerportserver.local/Reports and http://reportserver.local/Reportserver and verify if that is working. If yes, then go back to the Reports one and then click on “SystemCenter” and “ServiceManager”.

There you can see two database connection symbols, you have to change there the password for the changed user.

image

 

Back again the SCSM Console you will see that the reports are working again. Zwinkerndes Smiley

Advertisements