My SharePoint farm was running properly. Suddenly all web applications were inaccessible. When checked Widows event log I found the following error.
Target Principal name is incorrect,Cannot generate SSPI Context
We are using NTML authentication. I tried to connect to SQL Server using SQL Server Management Consle. It is giving the same error. I can log into the SQL server locally but not from any other computer in the network. Only SQL authentication works within network, windows authentication is not working. Windows authentication is just working locally
What can be the issue?
fantastic, this is problem with our farm couple of years ago…where duplicate SPN exist accidentally and our production went down.
Thanks for the reply. Everything was due to SPN. Still can’t figure out how SPN in Active Directory got modified. But the farm is now working.
The issue was resolved finally. It was too complicated for me to understand. I will try to explain what had happened. My SQL server was running under service account domain\a and the name of the computer was xyz. There was another account in active directory domain\a1. I found that in active directory the service principal name of account domain\a1 was MSSQLSvc/xyz.domain.com:1433 and MSSQLSvc/xyz:1433. Deleting this entry solved the issue. I don’t think I explained it properly but this is what I did.
So if simple things doesn’t solve your issue. I think you have to go through this article https://support.microsoft.com/en-us/kb/811889
Do I need to check SPN records if I have not setup kerberos?
