Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

3 Answers

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

share|improve this answer
    
Thanks for replying; however, I have already done this, and whenever the user tries to access the RS site, they cannot obtain access. No matter how many times they correctly enter their credentials, the log in dialog continues to appear. –  triniMahn Jul 2 '09 at 17:55
    
Then an admin, who does have access to the site, needs to add those users to the 'Browers' role. Try this. –  jinsungy Jul 2 '09 at 18:09
    
I've done that as well. Any other ideas? –  triniMahn Jul 2 '09 at 18:33
    
Maybe it is an IIS7 thing. I don't have much experience with it. I work mostly with IIS6. –  jinsungy Jul 2 '09 at 18:53
add comment

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?

share|improve this answer
    
Yes. They both have Windows Authentication enabled. Thanks for the reply. –  triniMahn Jul 7 '09 at 18:19
add comment
up vote 0 down vote accepted

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.