Users may be unable to view and execute the System Center Configuration Manager 2007 reports hosted on SQL Reporting Services

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

SYMPTOMS

Users may be unable to view and execute the System Center Configuration Manager 2007 reports hosted on SQL Reporting Services.

Problem 1: Trying to access http://<SQLServerName>/reports returns blank window. 

Problem 2: When trying to execute one of the reports you get the following error: 

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source '{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors.

CAUSE

This can occur due to a lack of permissions on the Reporting Server and the Database. 

RESOLUTION

The basic configuration to allow an end user to view and execute the Configuration Manager Reports hosted via Reporting Services Point are as follows: 

1. Create a Global Security Group for users with Read access to the Reports.
 
2. Add all of the users to this group who need to access to the Reports. 

3. Open the Reports website with admin privileges (e.g. http://<SQLServerName>/reports).

4. Click on the Properties Tab > Click on New Role Assignment.

5. In the Group or User name box type in the domain\<GlobalSecurityGroup> you created in step 1.

This will allow those users to view the reports but will fail to execute them. They will get the error described in Problem 2.

To resolve Problem 2 follow the below steps: 

1. Add the Global Security Group in SQL using the SQL Server Management Studio Security > Logins > New Login > User Mapping.

2. Check the box for the SCCM DB and Check “db_datareader” role.


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: 2428400 - Last Review: October 4, 2010 - Revision: 3.0
APPLIES TO
  • Microsoft System Center Configuration Manager 2007 R2
Keywords: 
KB2428400

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