December 19, 2008 at 12:22 pm
Can you connect to all the servers in the chain directly and get a Kerberos connection?
K. Brian Kelley
@kbriankelley
December 19, 2008 at 12:26 pm
Brain
I am not sure what you are asking, sorry abt it.
I can connect to all servers by RDP'ing but when i RDP into serverA and connect to ServerB and pull some data from SErver C it gives an error.
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
December 19, 2008 at 12:41 pm
Can you make a connection via SQL Server Management Studio to each one and each connection be via Kerberos authentication?
K. Brian Kelley
@kbriankelley
December 19, 2008 at 12:55 pm
I can connect to all the servers from SSMS with my domain account.
and when i run this query i get KERBEROS for my login but for other logins and the service account i still get NTLM
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
December 19, 2008 at 2:13 pm
Mike - are you sure all other connections are using the FQDN when connecting? Are you sure that all other connections are using a matching SPN record to connect?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply