3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Chapter 7: Troubleshooting 99
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
To delete an existing SPN, run setspn with -D. For example:
C:\>setspn -D MSSQLSvc/vqar13s11.ad1.polyserve.com:50004 vqar13s11
Unregistering ServicePrincipalNames for
CN=Administrator,CN=Users,DC=pdxad1,DC=polyserve,DC=com
MSSQLSvc/vqar13s11.pdxad1.polyserve.com:50004
Updated object
References
The following Microsoft documents provide additional information:
Windows 2000 Resource Kit Tool: Setspn.exe
How to: Enable Kerberos Authentication on a SQL Server Failover Cluster
How to use Kerberos Authentication in SQL Server
Microsoft NTLM
querySpn.vbs Script
' Copyright (c) Microsoft Corporation 2004 -
' File: querySpn.vbs
' Contents: Query a given SPN in a given forest to find the owners
' History: 7/7/2004 Craig Wiand Created
Option Explicit
Const DUMP_SPNs = True
Dim oConnection, oCmd, oRecordSet
Dim oGC, oNSP
Dim strGCPath, strClass, strSPN, strADOQuery
Dim vObjClass, vSPNs, vName
ParseCommandLine()
'--- Set up the connection ---
Set oConnection = CreateObject("ADODB.Connection")
Set oCmd = CReateObject("ADODB.Command")
oConnection.Provider = "ADsDSOObject"
oConnection.Open "ADs Provider"
Set oCmd.ActiveConnection = oConnection
oCmd.Properties("Page Size") = 1000
'--- Build the query string ---
strADOQuery = "<" + strGCPath + ">;(servicePrincipalName=" + strSPN + ");" & _
"dnsHostName,distinguishedName,servicePrincipalName,objectClass," & _
"samAccountName;subtree"
oCmd.CommandText = strADOQuery
'--- Execute the query for the object in the directory ---
Set oRecordSet = oCmd.Execute