When trying to connect to a SQL Server using Windows authentication you might get the following error: "The target principal name is incorrect. Cannot generate SSPI context."
This is a Kerberos authentication failure that causes connectivity issues with SQL Server when using Windows integrated authentication. Here is some guidance about the issue.
How to troubleshoot the "Cannot generate SSPI context" error message (microsoft.com)Open the ODBC Data Sources in Windows and create a connection to SQL Server using the same server and database that is having issues. Select Windows authentication. When testing the connection, you will get the same error as in Toad products.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center