This page discusses the usage of the “Azure SQL Database” checkbox. In ACM 9. 1 and later it is labeled “Azure SQL Database”. This checkbox setting is referenced used during ACM database upgrades and database creation. It does not pertain to the type of security used when connecting to the database. It must be checked when connecting to an Azure SQL Database.
...
Important Distinctions
SQL Server on Azure VM: This is Microsoft SQL Server running on a virtual machine in the cloud, It is the EXACT SAME as if it ACM were accessing Microsoft SQL Server running on a machine in the office.
...
| Info |
|---|
PaaS can mean either the Azure SQL Managed Instance OR Azure SQL Database. The exact environment makes a difference to ACM. |
The purpose for the checkbox
This box must be checked when connecting to an Azure SQL Database.
Database versions 19 and 31 both have changes that need to be applied differently dependent upon the type of SQL Database. In order for these changes to occur, this checkbox to must be properly checked.
VERSION 19
Version 19 has creates different versions of the stored procedure “asi_CreateRunOnceJob_W3Steps” – one for Azure SQL Database (in SqlUpdate_19Azure) and another for the other environments (SQlUpdate_19NonAzure).
This impacts the Delete Device History function which is called when you right click a device and chose choose delete history.
VERSION 31
SQLUpdate_31Azure creates two stored procedures that exist as features in the Microsoft SQL Server master database but do NOT exist in Azure SQL Database.
This is related to with how ACM computes space and memory size in the database.
| Info |
|---|
The takeaway: the Azure Database (soon to be named Azure The Azure SQL Database ) checkbox MUST be checked if they are ACM is connecting to an Azure SQL Database. |