SQL Server 2008, Kerberos and SPN

Posted by andrew007 on Stack Overflow See other posts from Stack Overflow or by andrew007
Published on 2010-04-30T19:51:06Z Indexed on 2010/04/30 20:37 UTC
Read the original article Hit count: 502

Filed under:
|
|

Hi,

I installed SQL Server 2008 on a Win XP SP2 workstation in a AD domain and configured to run with the "Network Service" account. In my error log I have the following message (Event ID:26037):

The SQL Server Network Interface library could not register the Service 
Principal Name (SPN) for the SQL Server service.  **Error: 0xd, state: 13**. 
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.

The strange thing is that I have another SQL Server 2008 installation in a Win 2003 server configured in the same way and there I do not have this message.

My questions are:

  • Does anybody know if there are limitations with Kerberos on Windows XP and SQL Server?
  • Why the SPN is not automatically registered on Win XP when I use the "Network Service" but it works on Windows 2003 server?

THANKS!

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about security