question

Felipe avatar image
Felipe asked

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?

sql-server-2000linked-server
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

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

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Felipe avatar image
Felipe answered

Through this blog i solved my problem.

Thank You Very much.

=]

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.