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 '09 at 10:54 AM in Default

Felipe gravatar image

Felipe
262 23 23 23

(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 '09 at 11:17 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

Through this blog i solved my problem.
Oct 13 '09 at 01:45 PM Felipe
(comments are locked)
10|1200 characters needed characters left

Through this blog i solved my problem.

Thank You Very much.

=]

more ▼

answered Oct 13 '09 at 12:27 PM

Felipe gravatar image

Felipe
262 23 23 23

Hi Felipe,

If Matt supplied the answer to your question, can you mark his answer as the correct one by clicking on the tick on the left hand side?
Oct 13 '09 at 12:52 PM Melvyn Harbour 1 ♦♦
Mel - do you have any control over what is in the FAQ? I think it might be worth adding that in there...
Oct 13 '09 at 01:03 PM Matt Whitfield ♦♦
Yep, we can edit the content for that - I'll get it added tomorrow!
Oct 13 '09 at 01:37 PM Melvyn Harbour 1 ♦♦
Nice one, thanks mate :)
Oct 13 '09 at 01:41 PM Matt Whitfield ♦♦
(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:

x472
x101

asked: Oct 13 '09 at 10:54 AM

Seen: 3179 times

Last Updated: Oct 15 '09 at 05:32 AM