April 12, 2011 at 9:58 am
I am currently in the process of transferring databases and reports to a new clustered SQL server. The issue I am running in to is for reports accessing data on a different SQL server I am receiving the error message below. This is happening when trying to view the reports in Report Manager, but runs fine when previewing the report in VS2008.
Cannot create a connection to data source 'DS_NAME'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have tried about every combination I can think of as far as security options in the data source definition. The preferred option is to have everything using integrated security because we manage everything by AD groups.
Just hoping someone out there may have an idea of what else I need to look at. Any assistance would be greatly appreciated!
Jeff
April 12, 2011 at 10:03 am
Looks like a Kerberos authentication issue with regards to delegation. Google it, theres lots of info about setting up delegation and the appropriate SPNs.
See this thread for more info:
http://www.sqlservercentral.com/Forums/Topic1043330-359-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply