To resolve the error of  SSPI handshake failed. 
EXEC xp_readerrorlog     0,    1,    'SSPI handshake failed' 
The above code produces the Client IP address..
To detect the machine name type nslookup "IPaddress or Machine name" to get the desired result

Check
the authentication that sql is currently running under .
SELECT net_transport, auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid
If that authentication shows NTLM then consider
the below troubleshooting methods 
Look for the current and archive logs to identify the SPN error as  per below
The success code 
![clip_image006[4]](https://mssqlwiki.files.wordpress.com/2013/12/clip_image0064_thumb.jpg?w=891&h=43)
The error code 

 
No comments:
Post a Comment