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


SQL authentication reporting services

Posted on 2009-04-21
Medium Priority
Last Modified: 2012-05-06
We want to use Windows Authentication to log on to the SQL Server for the reports however when we try this we get the following error message in the SQL Server Error Log:

Login failed for user NT AUTHORITY\ANONYMOUS LOGON Token based server access validation failed with and infrastructure error.

Ive done some searches on Google and it appears that the issue is down to the login details being lost between the Reporting Services server and the SQL database server, and that the SQL server needs the Trust this computer for delegation to specified services only setting enabled or something like this.
windows 2008 sql 2008
Question by:mhamer
  • 6

Author Comment

ID: 24192106
"      An error has occurred during report processing. (rsProcessingAborted)
o      Cannot create a connection to data source 'CorpRpt'. (rsErrorOpeningConnection)
§      For more information about this error navigate to the report server on the local server machine, or enable remote errors

database and reporting services are on diffrent 2008 boxes  IIS is not installed on either.

Expert Comment

ID: 24204683
I have experience the same error in the past.  This is the classic "double hop" issue.  Client to SSRS and then SSRS to SQL Server.  To resolve this you'll need to set up Kerberos between the SSRS server and the SQL Server.  Fortunately for me, I just had to ask our network team and they did it for me.  There are a lot of sites that talk about setting up Kerberos.  Here is a good article to start with.  http://blogs.technet.com/askds/archive/2008/06/13/understanding-kerberos-double-hop.aspx

Author Comment

ID: 24212758
Hi, thanks, now done that but still getting the error
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.


Author Comment

ID: 24212828
no IIS in use  bit stuck   (2008 reporting services doesnt rely on IIS)

Author Comment

ID: 24352459
Hi any more help please?
LVL 96

Accepted Solution

Bob Learned earned 1500 total points
ID: 24394541
Wow, you have an interesting challenge on your hands!!  There might not be enough evidence to support my assumptions (ASP.NET or other equivalent web site).  It sounds like you are allowing anonymous access to your web site, which means that different credentials are used to authentication.  The current user's credentials are used when you are using Windows authentication for a web site, but not Forms authentication, and not when anonymous is allowed.

Author Comment

ID: 24399878
no anonymous users.

should just be using the users window credentials from start to finish with out challenging them

it works fine when reporting services and sql are on the same box

Author Closing Comment

ID: 31572611
It is the double hop issue  getting it working in our enviroment is the next step    works fien in test lab though  thanks.

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

578 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