Failure to register an SPN - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Failure to register an SPN

Author

Topic

Tizita
Starting Member

12 Posts

Posted - 2008-07-10 : 06:38:21

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.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-10 : 21:45:18

quote:

This is an informational message. Further action is only required if
Kerberos authentication is required by authentication policies.

Well does that situation apply to your environment?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Tizita
Starting Member

12 Posts

Posted - 2008-07-11 : 07:49:03

Yes because in order for users to connect to SQL Server they would need the Kerberos authentication.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-11 : 22:49:28

Take look at this one:

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx

gedwards
Starting Member

19 Posts

Posted - 2008-07-15 : 15:39:50

I've found that ADSI Edit.msc is much friendlier to use when registering an SPN than SETSPN.exe
Format of the SPN varies slightly between services and versions of software.
Have you set up Kerberos before? This requires a Domain admin to setup the SPN's
Greg E

Greg E

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources