SQL Reporting Services 2008 Windows Authorization

Hi All--

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!
rz1224Asked:
Who is Participating?
 
rz1224Connect With a Mentor Author Commented:
My problem was with Internet Explorer Enhanced Security Configuration installed on a client version of IE & not with SQL Server Reporting Authorization.  Removed it and everything works fine...
0
 
planoczCommented:
If you built a shared datasource connection you need to open it and click on the credentials then check the windows auth. box and save.
0
 
rz1224Author Commented:
Thanks for the comment Plano--but I don't think this is the issue.  Can't use windows auth on the data source because it does not reside on the Report Server.  In any event, I've stored a db datasource id/password on the report server and I can access/view the report & data once i enter my id/password in the dialog box (not the db credentials).  I'm probably wording my question incorrectly but what I need is for this to work as it did w/ SQL Reporting-- A user on our company network clicks a button in an Access application and the report generates/displays in IE without requiring them to enter their credentials.
0
 
rz1224Author Commented:
Problem was not with SQL Server Reporting Auth, but conflicts with Intern Explorer Enhanced Security Configuration.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.