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

Article ID: 2834789 - View products that this article applies to.
Expand all | Collapse all

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: April 10, 2013 - Revision: 1.0
Applies to
  • Microsoft System Center 2012 Service Manager
  • Microsoft System Center 2012 Service Manager Service Pack 1
Keywords: 
KB2834789

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com