SSRS Integrated SQL Authentication

I have SQL Server Reporting Services installed on one SQL Server and i am trying to run a report which retreives data from a different SQL Server.

My Active Directory account has the right permission to browse the reports folder, run the report and run the relevant SQL queries on the SQL Server but SSRS appears to be trying to connect to SQL as "NT Authority\Anonymous Logon".

I have anonymous access unchecked for the Reports virtual directory in IIS and Integrated Windows Authentication checked. I have local impersonation checked under asp.NET Application Settings (with the user/password left blank).

What am i missing?

Thanks

L
LVL 11
tickettAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
grayeConnect With a Mentor Commented:
Take a look at this article on how to configure SQL Servers to "play nice together"
http://technet.microsoft.com/en-us/library/ms189580.aspx 
0
 
novaspoonmanConnect With a Mentor Commented:
This is a kerberos "double-hop" scenario. There are a number of steps that need to be performed involving setting SPN's and delegation for the domain accounts under which services run.

Check these out:

http://www.sqlservercentral.com/articles/Security/65169/
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=51bf9f20-bd00-4759-8378-b38eefda7b99&displaylang=en

The latter article about CRM involves reporting services. The idea is the same.
0
 
tickettAuthor Commented:
Need to review when this project becomes priority again.
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.