search cancel

sqlserver probe - support for Azure SQL PaaS databases

book

Article ID: 255742

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are attempting to monitor Azure SQL Paas databases using the sqlserver probe.

Environment

Release : UIM 20.4

Resolution

The sqlserver probe supports the following SQL Server versions:
SQL Server 2012 (32 and 64 bit) including AlwaysOn Availability Groups support
(From version 4.90) SQL Server 2014 (32 and 64-bit) including AlwaysOn Availability Groups support
(From version 5.10) SQL Server 2016 (32 and 64-bit) including AlwaysOn Availability Groups support
(From version 5.31) SQL Server 2017 (32 and 64-bit) including AlwaysOn Availability Groups support
(From version 5.42) SQL Server 2019 (32 and 64 bit) including AlwaysOn Availability Groups support
(From version 5.60) SQL Server 2022 (64 bit) including AlwaysOn Availability Groups support

In general, To monitor Azure SQL Server It is recommended to use the Azure probe when deployed as platform as a service (PaaS).

However, the SQLServer probe supports monitoring the SQL Server if 


- The SQL Server is setup manually on a Azure VM (i.e. IaaS)

OR

- SQL Server provisioned as a Service (PaaS) and enabled with SQL Server Authentication (not through Active Directory). Also, ensure the connection has been tested through a client like SQL Server Management Studio (SSMS). We can't use probe's Windows Authentication or Robot Service Authentication, as the SQL Server has been instantiated as PaaS and will be abstracted from the hosting machine.