May 3, 2012 at 9:19 am
SQL Server 2008 R2 instances are installed on machine A and B respectively. Also, A is the middle server that has a linked server object configured which points to a SQL instance on machine B. I am running a VB.NET application from machine C as [companydomain\user1].
I get the error Login failed for user 'NT nt authority anonymous logon' The error is executing a stored proc on server A that uses a linked server to reference a table on server B.
The user [companydomain\user1] exists as the member of an AD group [companydomain\ApplicationUsers]
This [companydomain\ApplicationUsers] login exists in both sql server A and B.
Can you help me? Thanks
May 3, 2012 at 9:30 am
On the security page of the linked server properties, are any impersonated logins setup, and which option is selected in the 'For logins not defined in the list above, connections will:' section?
Thanks
May 3, 2012 at 9:37 am
Gazareth (5/3/2012)
On the security page of the linked server properties, are any impersonated logins setup, and which option is selected in the 'For logins not defined in the list above, connections will:' section?Thanks
Thank you for your reply. Yes ther are other users set up that are not in the above list.
May 3, 2012 at 9:43 am
the set up is the third one "Be made uisng the login's current_security' context
May 3, 2012 at 9:44 am
Have you looked at delegation?
http://msdn.microsoft.com/en-us/library/ms189580.aspx
The account under which SQL Server is running must be trusted for delegation.
There is a good guide of the subject here on database journal.
May 4, 2012 at 5:16 am
Yep, looks like you're hitting the double hop problem.
Jimbo's links should have the information you need to solve it.
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply