SQL Server Target principal name is incorrect and the SSPI context cannot be generated

Source: Internet
Author: User
Tags setspn

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.