When you attempt to register the SPN (Service Principal Name) using the Setspn utility, you will receive an error if the NetBIOS name of the computer where SQL Server 2000 is running is different from the domain name if the NetBIOS name of the computer where SQL Server 2000 is running is different from the domain name, when using the following syntax:

setspn -A MSSQLSvc/Host:port serviceaccount

The error will look similar to:

<b>setspn -A MSSQLSvc/JSI007.JSIINC.com:1433 SQLAccount

Registering ServicePrincipalNames for (null)

        MSSQLSvc/JSI007.JSIINC.com:1433

Failed to assign SPN to account '(null)', 0x57</b>
To workaround this behavior, use the following syntax:
<b>setspn -A MSSQLSvc/Host:port domainname/serviceaccount</b>

like:

<b>setspn -A MSSQLSvc/JSI007.JSIINC.COM:1433 JSIINC/SQLAccount</b>

Where:

<b>JSI007</b>      is the host name of the SQL Server.

<b>JSIINC</b>      is the Windows domain name.

<b>SQLAccount</b>  is the SQL Server domain account under which SQL Server service is running.
NOTE: The NetBIOS computer name of the SQL Server where the SPN is being registered is NOT JSIINC.