x

Linked Server - SQL 2000 - Login failed for user '(null)'

Friends,

I have a problem. I work with many servers and each server has only one sql server 2000 instance. Actually, all linked servers are configured with system administrator login (sa). For security, I need to change this. I want to configure a linked server to use "Be made using the login´s current security context" option but when I test this, the following error message appears.

Server: Msg 18452, Level 14, State 1, Line 1

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Server01 Server02

On Server02 SELECT * FROM Server01.database.owner.table (The error ocurrs only when I am logged with Trusted Connection)

I read some articles about Kerberos and SPN but apparently it is ok.

Somebody help me?

more ▼

asked Oct 13, 2009 at 10:54 AM in Default

avatar image

Felipe
262 23 23 26

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

2 answers: sort voted first

Have you seen this blog post from the SQL Server Protocols team?

more ▼

answered Oct 13, 2009 at 11:17 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

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

Through this blog i solved my problem.

Thank You Very much.

=]

more ▼

answered Oct 13, 2009 at 12:27 PM

avatar image

Felipe
262 23 23 26

(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:

x501
x129

asked: Oct 13, 2009 at 10:54 AM

Seen: 4301 times

Last Updated: Oct 15, 2009 at 05:32 AM

Copyright 2016 Redgate Software. Privacy Policy