failure to register an SPN
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 26037
Date: 07/07/2008
Time: 07:37:40
User: N/A
Computer: Computer name
Description:
The SQL Network Interface library could not register the Service Principal Name
(SPN) for the SQL Server service. Error: 0x2098, state: 15. 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.
Software/Hardware used:
Software/Hardware used:
ASKED:
July 15, 2008 11:50 AM
UPDATED:
July 15, 2008 6:25 PM
Answer Wiki:
Are you using Kerberos on your network? If not, this isn't a problem and can be ignored.
If you are, and you haven't setup an SPN you'll need to have a domain admin do this on your domain controller.
This <a href="http://technet2.microsoft.com/windowsserver/en/library/318642de-15a3-4478-beb0-8022696def511033.mspx?mfr=true">page </a>gives an example on how to setup an SPN for the SQL Server.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.