x

Linked Server Query Execution error

Hello,

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

vishal.dobariya gravatar image

vishal.dobariya
0 1 1 2

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

2 answers: sort voted first

hi,

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

Tauseef_jan gravatar image

Tauseef_jan
51 2 2 2

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][2] is another link to look over as well.

[2]: http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx
more ▼

answered May 15, 2012 at 06:24 PM

Shawn_Melton gravatar image

Shawn_Melton
5.4k 20 21 29

(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x599
x111

asked: Apr 27, 2012 at 03:22 AM

Seen: 960 times

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