Return
-
Title
Unable to perform a Schema Compare between two SQL Server -
Description
Unable to perform a Schema Compare between two SQL Server connections, as the following error message shows:
'The target principal name is incorrect. cannot generate the sspi context. (Microsoft SQL server error 0)'
Toad for SQL Server: 8.0.0.65 Xpert Edition (64-bit)
SQL Server source: Server version 15.0.4322.2 (SQL Server 2019)
SQL Server target: Server version 12.0.6444.4 (SQL Server 2014)It is possible to connect to both SQL Servers successfully.
A Connection was successfully established with the server, but then an error occurred during the login process. (Provided: SSL Provider, error:0 – The Target Principal name is incorrect)
-
Cause
Identified defect. -
Resolution
WORKAROUND:
NoneSTATUS:
Waiting for fix in a future release of Toad for SQL Server -
Defect ID
TSS-2194 -
Additional Information
To connect, you need to put the parameter TrustServerCertificate' = true into the database connection called, e.g. SERVER_001 which is the “SQL Server target: Server version 12.0.6444.4 (SQL Server 2014)”