You are currently offline, waiting for your internet to reconnect

Your browser is out-of-date

You need to update your browser to use the site.

Update to the latest version of Internet Explorer

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.

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

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
Feedback