Register an Azure SQL Server VM with the SQL IaaS Agent Extension

How to Register an Azure SQL Server VM with the SQL IaaS Agent Extension Using PowerShell and CLI When we install SQL Server in Azure VM. The SQL IaaS Agent Extension enables advanced management capabilities for SQL Server Virtual Machines (VMs) in Azure, such as automated backups, patching, and simplified license management. In this article, … Read more

Error while importing drivers into SCCM with SQL Server 2022

We get below error trying to import Drivers on to SCCM with SQL 2022 Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException Not found , property = CI_ID This issue occurs due to the Database compatibility with the SCCM Current branch. In order to fix this issue, we need to alter the CM DB compatibility from 160 to 150. Here is the … Read more

Change IP of a VM via Azure Serial Console Access (SAC)

Commands to Manage IP Configuration in SAC To work with the IP configuration, follow these steps: 1. Enter the Networking Context SAC uses command channels for different contexts. To switch to the network management context, use: SAC> cmdSAC> ch -si 1 This brings up the Command Line Interface of the Server. 2. View Network Interfaces … Read more