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?
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.
