SQL Server cannot authenticate using Kerberos because the Service Principal Name (SPN) is missing, misplaced, or duplicated

17 Feb

When you that message in e.g Microsoft System Center – check the detail for the alert.

In our case – I used the following command from the command prompt to solve it. Remember that the use which will run the command must have modify rights to your Active Directory:

setspn -s XXSERVER:1433 Accountname

Read more

http://technet.microsoft.com/en-us/library/cc731241.aspx

http://www.sqlservercentral.com/Forums/Topic1407204-1550-1.aspx

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: