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?
This method for testing is very helpful because it takes less than a half minute to understand that something is not working and the good thing is that this is an out of the box tool in Windows.
Just navigate to any folder you like and create an empty text file. You can name it “TestSqlConnection” for example. Rename the file extension from txt to UDL.
From there you should be able to see if your web front ends are able to communicate to your SQL Server.
