At times, we may require to remove a wrongly created SPN entry. The syntax for removing a SPN entry is:
setspn.exe -D “SPN entry, which needs to be removed” “Service Account or Server Name”
Over the weekend, I was working on my lab to simulate an issue, while I observed that the SPN registration was failing on one of my test server. To fix the issue, I had to remove the SPN entry. I used the below command to remove the SPN entry as it was configured for the SQL server service account.
setspn.exe -D “MSSQLSvc/KRISHNA03.SKGLAB.LOCAL:1433” “SKGLAB\SQLSvc-SQL2012”
Happy Learning 🙂 !!!