Removing a rogue SPN

1) Remove SPN -

C:\Users\TEMP>

setspn -d MSSQL$SQL2008/DW1-SQLDEV-02.DW1.local dw1\sqlservicese

ver

Unregistering ServicePrincipalNames for CN=SQLServiceServer,CN=Users,DC=DW1,DC=

ocal

MSSQL$SQL2008/DW1-SQLDEV-02.DW1.local

Updated object

2) List SPNs (check it has gone) -

C:\Users\TEMP>

setspn -l dw1\sqlserviceserver

Registered ServicePrincipalNames for CN=SQLServiceServer,CN=Users,DC=DW1,DC=loc

l:

MSSQLSvc/DW1-SQLUAT-02.DW1.local:SQL2008

MSSQLSvc/DW1-SQLDEV-02.DW1.local:SQL2008

MSSQLSvc/DW1-SQLDEV-02.DW1.local

MSSQLSvc/DW1-SQLQA-02.DW1.local:SQL2008

MSSQLSvc/DW1-SQLPRO-05.DW1.local

MSSQLSvc/DW1-SQLPRO-03.DW1.local

MSSQLSvc/DW1-SQLPRO-03.DW1.local:1433

MSSQLSvc/DW1-SSIS-01.DW1.local:1433

MSSQLSvc/DW1-SSIS-01.DW1.local

MSSQLSvc/DW1-SSIS-02.DW1.local:1433

MSSQLSvc/DW1-SSIS-02.DW1.local

MSSQLSvc/DW1-DPM-01.DW1.local:1433

MSSQLSvc/DW1-DPM-01.DW1.local

MSSQLSvc/DW1-SQLPRO-05.DW1.local:1433

MSSQLSvc/DW1-SQLPRO-01.DW1.local:1433

MSSQLSvc/DW1-SQLPRO-01.DW1.local

MSSQLSvc/DW1-SQLQA-02.DW1.local:1433

MSSQLSvc/DW1-SQLUAT-02.DW1.local:1433

MSSQLSvc/DW1-SQLDEV-01.DW1.local:1433

MSSQLSvc/DW1-SQLDEV-01.DW1.local

MSSQLSvc/DW1-DPM-01.DW1.local:49270

MSSQLSvc/DW1-SQLQA-01.DW1.local:1433

MSSQLSvc/DW1-SQLQA-01.DW1.local

MSSQLSvc/DW1-SQLUAT-01.DW1.local:1433

MSSQLSvc/DW1-SQLUAT-01.DW1.local

MSSQLSvr/DW1-SQLQA-02.DW1.local

MSSQLSvr/DW1-SQLQA-02.DW1.local:1433

MSSQLSvc/ZZZ-SQLTEST-01.DW1.local:1433

MSSQLSvc/ZZZ-SQLTEST-01.DW1.local