DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2834789 - Last Review: April 10, 2013 - Revision: 1.0

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 (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

Applies to
  • Microsoft System Center 2012 Service Manager
  • Microsoft System Center 2012 Service Manager Service Pack 1
Keywords: 
KB2834789
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support