4

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

I've tried to give domain users access both through the site itself and through Management Studio, but whenever a user tries to access the site, they are prompted by the browser for their credentials, but they are not able to log in.

I know that this shouldn't be difficult to do!

UPDATE: SSRS site is running on IIS7

TylerH
  • 133
triniMahn
  • 51

3 Answers3

2

Browse to http://servername/Reports/. Go to the Properties tab and add New Role Assignments as necessary.

jinsungy
  • 368
1

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

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

triniMahn
  • 51
0

Don't have a lot of IIS7 experience, but have you checked the Reports and ReportServer virtual directories in IIS and made sure they are set up for Integrated Windows Auth?