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.
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?