Version

Argent Advanced Technology 5.1A-2301-A or above

Date

Monday, 5 December 2022

Summary

Argent for SQL Server has been enhanced to monitor Microsoft Azure SQL Management Instance

Technical Background

Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service

Argent for SQL Server now monitors Microsoft Azure SQL Management Instance

Argent for SQL Server provides SQL Query Rules that execute a single customizable SQL statement, stored procedure, or a T-SQL block on a specified SQL Server instance or database

Currently, the SQL Query Rule uses the built-in ODBC driver SQL Server to connect to a SQL Server instance

The SQL Query Rule throws the following exception when connecting to the target Azure SQL Management Instance with TLS v1.2 enabled:

“Login failed due to client TLS version being less than minimal TLS version allowed by the server”

This is because the SQL Driver does not support TLS v1.2

The ODBC drivers supporting TLS v1.2 are ODBC Driver 11 for SQL Server and later

A new property named ODBC Driver is added in CMDB-X; there you can choose the ODBC driver to use in the SQL Query Rule

By default, SQL Query Rule uses the registry value DEFAULT_SQLSIERVER_DRIVER in HKLM\Software\Argent\COMMON as driver name

Click For Full Size

Resolution

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