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?
No, only changes made to the SQL server were that I installed Telnet Client
I have not configured Kerberos.
Neither the service account nor the password of service account of SQL is changed.
The only minor changes I made on SQL server were that I installed Telnet Client.
Have try to reboot the server ?
It sounds like Windows is not able to validate the user against the AD.
Did you configure the Kerberos authentication, this error usually occurred:
- Duplicate SPN generated
- SPN on SQL got Change
- Service account being used for SQL modified.
