Thursday, April 6, 2017

Fix for “The target principal name is incorrect. Cannot generate SSPI context.”

After changing a service account running SQL server, I get an error when I connect to SQL server from Management Studio from my laptop or other servers. The error is below.

“The target principal name is incorrect.  Cannot generate SSPI context.”

To Fix this,

You need to register the service account in SPN.

MSSQLSvc/ Server1.domain.us.dom Domain\ServiceAccount
MSSQLSvc/ Server1.domain.us.dom:1433 Domain\ServiceAccount


After SPN is registered successful, the error is resolved. Thank you.

How to add a Database to AlwaysOn Availability Group with four different options

To add a database to an existing AlwaysOn availability group, MS has given us four options to choose from Automatic seeding Full database an...