Error: KDC Event ID 11 There are multiple accounts with name MSSQLsvc

Source: KDC

Event ID: 11

Description: There are multiple accounts with name MSSQLSvc/databaseserver1.local:1433 of type DS_SERVICE_PRINCIPAL_NAME

This error occured when a computer join a domain in the same name and same user in the network. Or Starting the SQL server services and SQL server agent in different user resulting to duplicate SERVICE PRINCIPAL NAME in one port which is 1433.

To Solve this use the setspn tools from your domain controller. If this tools is not installed in your domain controller you can download it in microsoft.

First locate the duplicate Name
1. run>cmd.exe
2. In your command prompt type:

setspn -x

This will view the duplicate name, take note of the computer name and the user (Ex: databaseserver1,Administrator)

Finally you can now delete the duplicate SPN
1. In your command prompt type:

setspn -D MSSQLSvc/databaseserver1.local:1433 Administrator

2. Check again if the duplicate still exist by typing the  setspn -x

DONE!

Hope this helps. It takes me two days solving this kind of error in my server.