Service Principal Name (SPN)

[ptheriault]

I fonud this error in the log of my new SQL 2005 server. Is this a big deal? Our domain is AD.
The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.

 

[mrdenny]

This will only be a problem if your domain requires kerbos for authentication. Check with your sysadmins to see if it's required.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com