Duplicate SPN – MS SQLServer

30 Jan

ERROR:There are one or more duplicates of the following service principal names found in the active directory domain services: mssqlsvc/computername.domain.local:1433

 

– You have to delete the spn for mssqlsvc with the command (remember to log in as domain admin/admin):

setspn -d mssqlsvc/computername.domain.local:1433 computername

http://social.technet.microsoft.com/Forums/en-US/FCSNext/thread/220cc8f0-313f-451c-81fb-2f7f6d90debd

http://qa.social.technet.microsoft.com/Forums/en/FCSNext/thread/d0248ed5-5670-42e1-9016-4d66286f979c

http://social.technet.microsoft.com/Forums/en-US/identitylifecyclemanager/thread/542f3b30-41f6-4299-b373-5b1f3dc16269/

http://social.msdn.microsoft.com/Forums/en-SG/sqlsecurity/thread/12fe7757-5842-4465-bd79-4530c2530255

http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/162970eb-bb0b-410e-9caa-08169f0bcf95

 

 

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: