SQL Reporting Services 2008 Windows Authorization
Posted on 2011-03-15
Having a heck of a time getting windows auth to work with SQL Reporting Services 2008. It's a new instance installed on Server 2008 and once a report is deployed it should be able to be viewed by any user on the network. When attempting to open the report from a client machine (via URL link) I get the connect to computername.domain.local dialog box. Once I enter the info the report generates as it should but it's not acceptable to have our users enter their creds every time they access a report.
In a addition to adding 'domain users' to the root directory in the report manager and in the report server 'local users/SQLServerReportServerUser' group and enabled windows auth in IIS. Don't know where else to go...
Any suggestions would be appreciated--not sure if i provided enough info, just ask if more needed. Thanks!