Linked Server Query Execution error


I am facing weired problem whenever trying to fire query over linked server.

I have Sql 2k8 server enterprise edition which has linked server pointing to Sql 2k8 R2 server enterprise edition.

i have windows authenticated login created on both db and used the same in linked server access rights/credential.

Whenever i m firing select query , it shows a message that "Login Failed for NT AUTHORITY\Anonymous logon."

I tried to search a lot on internet but nothing could resolve my issue. This is i am facing on production.

I would be very thankful if you have any resolution to this problem. Will wait for your reply. Thanks.

~ Vishal

more ▼

asked Apr 27, 2012 at 03:22 AM in Default

avatar image

0 1 1 2

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first


Are both the servers running under the same service account? if not then they should be.

more ▼

answered May 02, 2012 at 02:25 PM

avatar image

81 3 4 6

source is running on local system whereas destination is running on sqladmin domain user account. Please note that i have been firing this query from Query analyzer.

May 15, 2012 at 05:38 PM vishal.dobariya
(comments are locked)
10|1200 characters needed characters left

It sounds like you need to configure your SQL Server instances for Kerberos authentication. When trying to go over more than one hop, which you are (client > 1st SQL instance > 2nd SQL instance via linked connection), Kerberos authentication is the only protocol that SQL Server can use to do this action. NTLM cannot pass your credentials.

Here is another link to look over as well.

more ▼

answered May 15, 2012 at 06:24 PM

avatar image

6.6k 21 26 34

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 27, 2012 at 03:22 AM

Seen: 1108 times

Last Updated: May 15, 2012 at 06:25 PM

Copyright 2018 Redgate Software. Privacy Policy