Selecting a report in the System Center 2012 Service Manager console fails with the following error:
An error has occurred during report processing (rsProcessingAborted)
Cannot impersonate user for data source 'DWDataMart' (rsErrorImpersonatingUser)
Log on failed. Ensure the User name and password are correct. (rsLogonFailed)
The parameter is incorrect
This can occur if Data Sources are missing entries or are incorrectly configured in SQL Server Reporting Services (SSRS).
To resolve this issue, use the following query to get the data sources:
select Path,Cast(Cast(Content as varbinary(max)) as varchar(max))
where Type = 5
Once you obtain the Data Sources, verify the Data Source string for each module and re-enter as necessary.
Article ID: 2834789 - Last Review: 04/10/2013 21:31:00 - Revision: 1.0