Wednesday 12 August 2009

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

No comments: