|
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?
(comments are locked)
|
|
Have you seen this blog post from the SQL Server Protocols team? Through this blog i solved my problem.
Oct 13 '09 at 01:45 PM
Felipe
(comments are locked)
|
|
Through this blog i solved my problem. Thank You Very much. =] 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)
|
