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

I am trying to use Windows Authentication on a SQL Server 2008 Report Server that connects to a 'remote' SQL Server 2008 Enterprise server. If I store the login credentials with the datasource everything works fine. The reports limit what information can be selected based on the user's account. I need to be able to use Windows Authentication. If I set the data source to Windows authentication when I try to go to the report it prompts me for my us/pw but every time I enter this information the box pops up again. Both servers are on the same subnet. If I put a copy of the database on the report server it will run without issue.

Environment: Data Server SQL 2008 Enterprise SP1 Windows 2008 Enterprise Physical Server

Report Server SQL Server 2008 Enterprise SP1 Windows 2008 Enterprise VMware ESX 3.5 Virtual

Any Assistance would be greatly appreciated

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Definitely sounds like a double-hop issue. You will need to set your environment to use Kerberos authentication between your clients, the report server, and the data server.

For Kerberos to work, you'll need the reporting service and SQL database service to be running as domain accounts rather than local accounts (Local system/Network service), and you'll need to create SPNs for the reporting service account in Active Directory. See this article for information about the SPNs that you need to create. Google will also turn up a bunch more information on how to configure things.

edit: System no longer thinks I'm a spammer so I can post multiple links :P

share|improve this answer
    
I will give this a shot and let you know. Thank you for you help. –  jgardner04 Nov 10 '09 at 15:31
    
As it turns out I had to register a Server Principal Name (SPN) to get it to work. Here is a link about it on MS. site. technet.microsoft.com/en-us/library/cc281382.aspx –  jgardner04 Aug 5 '10 at 16:19

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.