Edit

Share via


Azure extension for SQL Server system objects

Applies to: SQL Server

This article lists system objects - files, registry keys, Windows services and tables deployed and managed by the Azure extension for SQL Server.

Windows server files

Path Description
%ProgramFiles%\AzureConnectedMachineAgent\* azcmagent CLI and instance metadata service executables
%ProgramFiles%\AzureConnectedMachineAgent\GCArcService\GC\* Extension service executables
%ProgramData%\AzureConnectedMachineAgent\* Configuration, log, and identity token files for azcmagent CLI and instance metadata service
%ProgramData%\Application Data\Microsoft\Crypto\RSA\MachineKeys Windows certificate private keys

SQL Server files

Path Description & notes
%ProgramFiles%\Sql Server Extension\* Extension program files
%SYSTEMDRIVE%\Packages\Plugins\Microsoft.AzureData.WindowsAgent.SQLServer\<extension_version>\* Extension executables
%SYSTEMDRIVE%\Windows\system32\extensionUpload\* Usage files
C:\Windows\System32\Tasks\Microsoft\SqlServerExtension XML for scheduled task for providing privileges
C:\Windows\ServiceProfiles\SqlServerExtension\AppData\Local\Microsoft SQL Server Extension Agent\* When configured for least privilege

Feature application
C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft SQL Server Extension Agent\* When not configured for least privilege

Feature application

Note

Existing servers with the extension from the November 2024 release or later will automatically have least privileged configuration applied. This application will happen gradually.

To prevent automatic application of least privilege, block extension upgrades to the November 2024 release.

Windows Services

Service name Display name Process name Description
SqlServerExtension Microsoft Sql Server Extension Service SqlServerExtension.exe Connects your SQL Server instance to Azure.
himds Azure Hybrid Instance Metadata Service himds.exe Synchronizes metadata with Azure and hosts a local REST API for extensions and applications to access the metadata and request Microsoft Entra managed identity tokens
GCArcService Machine configuration Arc Service gc_arc_service.exe (gc_service.exe earlier than version 1.36) Audits and enforces Azure machine configuration policies on the machine.
ExtensionService Machine configuration Extension Service gc_extension_service.exe (gc_service.exe earlier than version 1.36) Installs, updates, and manages extensions on the machine.

Virtual service accounts

Virtual Account Description
NT SERVICE\himds Unprivileged account used to run the Hybrid Instance Metadata Service.
NT Service\SQLServerExtension Unprivileged account used to run the SQL Server Extension Service in least privilege mode.

Registry keys

Base key: HKEY_LOCAL_MACHINE

Key Description & notes
SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRegistryName>\MSSQLSERVER Microsoft Entra ID registry key
SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceRegistryName>\PurviewConfig Purview registry key
SOFTWARE\Microsoft\SystemCertificates Windows certificate registry key

Tables

In each instance of SQL Server enabled by Azure Arc, the extension creates the following tables in msdb:

  • dq.arcJobTriggers00
  • dt.arcJobDefinitions

These tables store background job definition and execution history. Background jobs perform scheduled and user-initiated actions. These tables allow long-running jobs to automatically resume in the event that the Azure Extension for SQL Server is restarted.