Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)
Ever since the last patching window, we have some scheduled jobs on SQL production that are intermittently failing, producing the error "Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)" The jobs run fine if they are not scheduled.
We have tried removing the dynamic SQL, and other suggestions but we still get the errors.
Some articles on the web indicate that it might be a problem with the version of ODBC drivers that are installed.
https://www.sqlservercentral.com/forums/topic/unknown-token-received-from-sql-server-2
We are running SQL 2016.
Is MS aware of this problem? Is there a solution for it?
The scheduled jobs run fine on SQL TEST.
SQL TEST has ODBC Driver 13 for SQL Server: 2017.140.1000.169
SQP PROD (scheduled jobs fail here) has ODBC Driver 13 for SQL Server: 2015.131.6455.02
Does the SSMS SQL Agent scheduler actually use ODBC?
Any help would be greatly appreciated.
Thanks.