Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2009-01-08 : 15:09:32
|
| Here is my setup for link serverServer4 = KERBEROS/Standard/Mixed Mode/delegation set to 1Server5 = KERBEROS/Enterprise/Mixed Mode/delegation set to 1when i connect to Server5 and query select * from Server4.master.dbo.sysdatabases, I get an error Msg 18456, Level 14, State 1, Line 1Login 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_idI get KERBEROS only for my login and the rest including the service account i get NTLM, is this something wrong setup?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 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-09 : 09:39:54
|
| http://www.databasejournal.com/features/mssql/article.php/3696506/Setting-Up-Delegation-for-Linked-Servers.htm |
 |
|
|
|
|
|
Link Server Setup