Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2005 Reporting Services Access issues

Status
Not open for further replies.

cglopez

IS-IT--Management
Aug 12, 2008
2
As a local admin, I can access/modify reports by going to while I am on the box, or I can view reports when logging in to How do I grant a domain user group access to view the reports? I tried to do it through SSRS, but everyone keeps receiving a permissions error. I tried to do it through SSMS, but it doesn't recgonize the domain group. I am obviously missing something, but I don't know what. Any help would be greatly appreciated.
 
In each section of the reporting site, there is a "properties" tab. If you click this, one of the options along the left hand side is "security." This is where you can grant different types of access, the granularity dependent upon which object you are working with (individual report, folder, etc.).
 
Okay, I granted access on the home page, and now the users can see the reports, however, when they click on any one of them, they get a cannot connect to datasource error.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top