January 8, 2009 at 12:45 pm
Here is my setup for link server
Server4 = KERBEROS/Standard/Mixed Mode/delegation set to 1
Server5 = KERBEROS/Enterprise/Mixed Mode/delegation set to 1
when i connect to Server5 and query
select * from Server4.master.dbo.sysdatabases, I get an error
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
When I checked authentication of the login by running this query
SELECT
s.session_id
, c.connect_time
, s.login_time
, s.login_name
, c.protocol_type
, c.auth_scheme
, s.HOST_NAME
, s.program_name
FROM sys.dm_exec_sessions s
JOIN sys.dm_exec_connections c
ON s.session_id = c.session_id
I get KERBEROS only for my login and the rest including the service account i get NTLM, is this something wrong setup?
January 8, 2009 at 12:50 pm
Is the login a user on the remote server? If not use option:
login using the current users security context and enter the login and password by going into the properties tab of ur linked server..
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 12:55 pm
Yes I do setup my link server to use current users security context but still the same error.
I was just wondering why only my login shows KERBEROS why not service account and other logins. I doubt if my i missed anything during authentication and delegation setup.
January 8, 2009 at 3:16 pm
Hope attached do help you in this.
MJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply