Solved

SSRS Integrated SQL Authentication

Posted on 2010-08-23
3
559 Views
Last Modified: 2012-05-10
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
Comment
Question by:tickett
3 Comments
 
LVL 41

Accepted Solution

by:
graye earned 250 total points
ID: 33501361
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
 
LVL 3

Assisted Solution

by:novaspoonman
novaspoonman earned 250 total points
ID: 33681572
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
 
LVL 11

Author Closing Comment

by:tickett
ID: 33883937
Need to review when this project becomes priority again.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sqlquerystress - To test db performance 8 42
Webservices in T-SQL 3 31
Show Results for Latest DateTime in a View 27 25
Help in Bulk Insert 9 33
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

770 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