CODEWITHSUNDEEP
sql-server-2005iis-7reportingservices-2005
triniMahn
triniMahn

Reputation: 278

Domain user access to SQL Server Reporting Services 2005 on IIS 7

What are the required steps to properly allow domain users access to reports via the Reporting Services web site?

What I've tried:

Result:

Upvotes: 1

Views: 2460

Answers (2)

triniMahn
triniMahn

Reputation: 278

I don't know why I didn't think of this before but I:

  • Added desired domain users to the "SQLServer2005ReportServerUser*$InstanceName*" group on the Windows 2008 machine running SQL Server Reporting Services
  • Added users to specific roles through reporting services web site (http://servername/reports)

AND now users are able to access the reporting services site!

Upvotes: 2

RolandTumble
RolandTumble

Reputation: 4703

I've been dealing with this exact issue recently. I still don't know the answer, but I think that at least part of it is to add the users to SSRS-specific groups (create them if needed through the SSRS Configuration manager).

Upvotes: 0

Related Questions