When you try to register the Service Principal Name (SPN)
by using the Setspn utility, and the NetBIOS name of the computer that is running Microsoft SQL Server
2000 differs from the domain name, the following syntax is
setspn -A MSSQLSvc/<Host>:<port> <serviceaccount>
This syntax will return the following error:
C:\>setspn -A MSSQLSvc/lphBar2.hemlock.com:1433 delegation
Registering ServicePrincipalNames for (null)
Failed to assign SPN to account '(null)', 0x57
The following information applies to the examples in this article:
- "Lphbar2" is the host name of the computer that is running SQL Server.
- "Hemlock" is the Microsoft Windows 2000 domain name.
- "Delegation" is the SQL
Server domain account under which the SQL Server service is running.
is the NetBIOS name of the computer that is running SQL Server. This is the computer where the SPN is being registered.
To work around this problem, you can register the SPN by using the following syntax.
setspn -A MSSQLSvc/<Host>:<port> <domainname>\<serviceaccount>
For example, use the following syntax.
C:\>setspn -A MSSQLSvc/lphbar2.hemlock.com:1433 hemlock0/delegation
that the NetBIOS name of the computer that is running SQL Server (hemlock0) and the Windows 2000 domain
name (hemlock) are different.
For information about delegation, see the "Security Account
Delegation" topic in SQL Server 2000 Books Online.