Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Setspn fails if domain name differs from NetBIOS name where SQL Server SPN is registered
Article ID: 277658 - View products that this article applies to.
This article was previously published under Q277658
BUG #: 236041 (SHILOH)
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 incorrect.
This syntax will return the following error:
Note The following information applies to the examples in this article:
To work around this problem, you can register the SPN by using the following syntax.
For example, use the following syntax.
Notice 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.