Explanation wanted about the Service Principal Name ( SPN )

Hello,

In the ErrorLog of my Sql Server , i found this line :

2007-06-26 05:35:18.37 Serveur The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. 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.

Operating System XP Home SP2

SQL Server 2005 Express Edition with Advanced SP1 )

( idem for another workstation with XP Pro SP2 and same version of SQL Server 2005 Express

My problem is :

i want use the windows authentification but my computers are on Worhkgroup linked by a router ( no window server )

i have read that's possible to connect from a remote computer to a computer having a SQL Server 2005 Express through SPN

How can i do it ? ( activating NTLM ? but how ?)

I'm writing a C# program which must be executing on several computers with a SQL Server 2005 Express installed on a particular computer. These computers will belong to a domain of Windows Server 2003.

As i can't connect to this "normal" network, i am trying to simulate this network at home because i want to test this program and especially the possible locks problems.

I don't know whether i'm querying with the "correct" forum.

Sorry for my poor english.

I shall appreciate any help about this problem

Have a nice day

hi,

actually is not "a problem", as the message in the log already states.. it's informational only..

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

http://support.microsoft.com/kb/909801/en-us

regards