Selecting a report in Service Manager fails with "Cannot impersonate user for data source 'DWDataMart'"

Symptoms

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

Cause

This can occur if Data Sources are missing entries or are incorrectly configured in SQL Server Reporting Services (SSRS).

Resolution

To resolve this issue, use the following query to get the data sources:

select Path,Cast(Cast(Content as varbinary(max)) as varchar(max))
from dbo.[Catalog]
where Type = 5

Once you obtain the Data Sources, verify the Data Source string for each module and re-enter as necessary.

Properties

Article ID: 2834789 - Last Review: Apr 10, 2013 - Revision: 1

Feedback