You are currently offline, waiting for your internet to reconnect

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


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))
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.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2834789 - Last Review: 04/10/2013 21:31:00 - Revision: 1.0

Microsoft System Center 2012 Service Manager, Microsoft System Center 2012 Service Manager Service Pack 1

  • KB2834789