Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Reporting Services 2008 Windows Authorization

Posted on 2011-03-15
4
Medium Priority
?
452 Views
Last Modified: 2012-08-14
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!
0
Comment
Question by:rz1224
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 35149959
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
 

Author Comment

by:rz1224
ID: 35150079
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
 

Accepted Solution

by:
rz1224 earned 0 total points
ID: 35150871
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
 

Author Closing Comment

by:rz1224
ID: 35178818
Problem was not with SQL Server Reporting Auth, but conflicts with Intern Explorer Enhanced Security Configuration.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question