Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

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.

↑ Back to the top

Cause

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

↑ Back to the top

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.


↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2428400
Revision : 1
Created on : 1/7/2017
Published on : 10/4/2010
Exists online : False
Views : 138