Solved

SSRS Integrated SQL Authentication

Posted on 2010-08-23
3
565 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
[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 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Agent Job Error 13 83
Using rowversion for incremental load of datawarehouse. 12 37
Need split for SQL data 7 50
learning MS SSIS 13 25
I have a large data set and a SSIS package. How can I load this file in multi threading?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

752 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