Logging of SPN auto-registration in SQL Server 2008

  • Article

I noticed today that when SQL Server automatically registers the SPN (service principal name) on startup, it gets logged now in the SQL error log.  For example:

The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/XYZ.xyzadc01.local:58628 ] for the SQL Server service.

The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/XYZSQL.xyzadc01.local:CAESAR ] for the SQL Server service.

The logging example was taken from a SQL Server 2008 instance running on a Windows 2008 failover cluster.  We see two SPNs get registered - one by TCP port (58628) and another by instance name (CAESAR).

If there are any failures in the auto-registration of an SPN, this will also get logged. This visibility in the SQL error log should improve overall supportability when Kerberos failures strike...