Error:

OLE DB provider "SQLNCLI11" for linked server "myserver01" returned message "Cannot generate SSPI context".

Msg -2146893022, Level 16, State 1, Line 0
SQL Server Network Interfaces: The target principal name is incorrect.

Possible Fixes:

In the Security section of the linked server, switch to “Be made using this security context” and provide a login SQL account.

Last modified: September 18, 2020

Author

Comments

Write a Reply or Comment