Both servers, like the environment, use the same domain account. SERVER03 SQL Server can connect to Server04 through Windows authentication, but Server04 through Windows Authentication Connection SERVER03 times the following error:
The target principal name is incorrect and the SSPI context cannot be generated.
PING Server03 or Ping-a Server03, it all looks normal, where exactly is the problem? The SSPI context could not be generated for many reasons, but I decided to start with the target principal name incorrectly. As follows:
Running Setspn-l Server03 and Setspn-l Server04 First, the results found that SERVER03 had more than two mssqlsvc-preceded SPNs.
Next, delete the two SPNs that begin with MSSQLSvc, setspn-d spn_name Server03
Finally restart Server03, and then use SERVER04 through Windows Authentication Connection Server03, found that the problem was lifted, successfully established a connection.
SQL Server Target principal name is incorrect and the SSPI context cannot be generated