//
you're reading...
ConfigManager 2007, Hot Fix/Kb's, System Center

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.

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.

Source :-http://support.microsoft.com/default.aspx?scid=kb;EN-US;2428400

Advertisements

About Abhishek Joshi

Abhishek Joshi having 8 years exp. in IT Industry and 5 exp in System Managment. Between Oct 2009 to Oct 2011 Abhishek was the only MVP in India for SCCM 2007 technology. Abhishek has started his online carrier from Blogcastrepository.com in Dec 2006 and post that actively participated on Technet forum.

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Visitors Location

RSS Abhishek Joshi’s TechNet Discussions

  • An error has occurred; the feed is probably down. Try again later.

Twitter Updates

  • RT @CMOMaharashtra: Government Of Maharashtra decides that all State roads will be toll tax free till 11th November midnight. 8 months ago
  • RT @nitin_gadkari: It has been decided to suspend Toll across all National Highways till midnight of 11th November to facilitate smooth tra… 8 months ago

Blog Stats

  • 64,984 hits
%d bloggers like this: