KBI 312041 Issue Addressed: SQL Query Rules With The ‘SQL Statement’ Option Failed When Running Against SQL Server That Uses A Trusted Connection


Argent Advanced Technology 2301-A and below


Monday, 27 February 2023


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


Upgrade to Argent Advanced Technology 5.1A-2304-A or above