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 '12 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 '12 at 02:25 PM

Tauseef_jan gravatar image

Tauseef_jan
51 1 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 '12 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 '12 at 06:24 PM

Shawn_Melton gravatar image

Shawn_Melton
5.3k 17 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x562
x101

asked: Apr 27 '12 at 03:22 AM

Seen: 798 times

Last Updated: May 15 '12 at 06:25 PM