Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 582
  • Last Modified:

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
0
tickett
Asked:
tickett
2 Solutions
 
grayeCommented:
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
 
novaspoonmanCommented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now