Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server - Kerberos and KRB_AP_ERR_MODIFIED

On a routine scan of Event Viewer System, Logs I found this message on 4 different servers  hosting SQL Server installations

 

The kerberos client received a KRB_AP_ERR_MODIFIED error from the server MYCOMPUTER$.  This indicates that the password used to encrypt the kerberos service ticket is different than that on the target server. Commonly, this is due to identically named  machine accounts in the target realm (MY.DOMAIN.NET), and the client realm.   Please contact your system administrator.

 

Why was this occurring?

 

1)      A client was using a DNS CNAME to point traffic to serverB after decommissioning serverA . Removing the CNAME would have resolved the issue

2)      An entry in the /etc/hosts file . After renaming a server and setting up a new one with the same name the host-entry was not updated and so the new server pointed to the IP address of the old one

 

 

See Also

Event ID 40960 Cannot generate SSPI context

Server sudden shutdown unavailable

Comments

Leave a comment on the original post [www.sqlserver-dba.com, opens in a new window]

Loading comments...