kerberos error message
Posted on 2014-01-21
One of my SQL servers pops a Error Code: 0x7 KDC_ERR_S_PRINCIPAL_UNKNOWN error every 15 minutes. Text of the error is
A Kerberos Error Message was received:
on logon session
Server Time: 0:0:1.0000 1/22/2014 Z
Error Code: 0x7 KDC_ERR_S_PRINCIPAL_UNKNOWN
Extended Error: 0xc0000035 KLIN(0)
Server Realm: XXXX.LOC
Server Name: MSSQLSvc/annie.XXXX.loc:1433
Target Name: MSSQLSvc/annie.XXXX.loc:1433@XXXX.LOC
Error Data is in record data.
Annie is another SQL server which this server sends log shipping to, and the errors occur at the interval of the LSbackups.
The quick link takes me to a MSFT page telling me how to reset stored passwords. Completed this on both servers involved with no improvement.
Went a step further and ran setspn.exe to verify no duplicate records.
I have rebooted Annie with no improvement, but do not want to reboot the production server unless it is sure to fix it. Nothing I read indicates it should be necessary.
Anybody more familiar with this?