KBI 312041 Issue Addressed: SQL Query Rules With The ‘SQL Statement’ Option Failed When Running Against SQL Server That Uses A Trusted Connection
Version
Argent Advanced Technology 2301-A and below
Date
Monday, 27 February 2023
Summary
SQL Query Rules with the “SQL Statement” option failed when running against SQL Server that uses a trusted connection
Technical Background
An exception is thrown when testing the SQL Query Rule with the default “SQL Statement” option against a SQL Server that uses a trusted connection.
The same Rule runs fine against any SQL server that uses SQL authentication.
This was a coding error and has now been addressed
Resolution
Upgrade to Argent Advanced Technology 5.1A-2304-A or above