Skip to content

connect-already-enabled.md

Latest commit

 

History

History
98 lines (63 loc) · 5.77 KB

connect-already-enabled.md

File metadata and controls

98 lines (63 loc) · 5.77 KB
title Connect SQL Server on a Server Already Enabled by Azure Arc
description Connect an instance of SQL Server to Azure Arc on a server that is already enabled by Azure Arc. Allows you to manage SQL Server centrally, as an Arc-enabled resource.
author anosov1960
ms.author sashan
ms.reviewer mikeray, maghan
ms.date 07/03/2025
ms.topic how-to

Connect your SQL Server to Azure Arc on a server already enabled by Azure Arc

[!INCLUDE sqlserver]

This article explains how to connect your SQL Server instance to Azure Arc on an Arc-enabled server. For example, you need to use this method to connect a SQL Server instance to Azure Arc at this time in US Government Virginia region, because automatic connection isn't currently available in that region. For this case, follow the steps under Connect.

If the physical or virtual server isn't connected to Azure yet, follow the steps in Connect your SQL Server to Azure Arc.

[!INCLUDE automatic]

Prerequisites

Verify that Microsoft.AzureArcData is registered in each subscription. Review instructions at Register resource providers.

Review all of the prerequisites at Prerequisites - SQL Server enabled by Azure Arc.

If the machine with SQL Server is already connected to Azure Arc, to connect the SQL Server instances, install Azure extension for SQL Server. The extension is in the extension tab of "Server - Azure Arc" resource as Azure Extension for SQL Server.

Important

The Azure resource with type SQL Server - Azure Arc representing the SQL Server instance installed on the machine uses the same region and resource group as the Azure resources for Arc-enabled servers.

Connect

Azure portal

To install the Azure extension for SQL Server, use the following steps:

  1. Open the Azure Arc > Servers resource.
  2. Search for the connected server with the SQL Server instance that you want to connect to Azure.
  3. Under Extensions, select + Add.
  4. Select Azure extension for SQL Server and select Next.
  5. Specify the SQL Server edition and license type you're using on this machine. Some Arc-enabled SQL Server features are only available for SQL Server instances with Software Assurance (Paid) or with Azure pay-as-you-go. For more information, review Configure SQL Server enabled by Azure Arc.
  6. Specify the SQL Server instance(s) you want to exclude from registering (if you have multiple instances to skip, separate them by spaces) and select Review + Create. :::image type="content" source="media/join/license-type-in-extension.png" alt-text="Screenshot for license type and exclude instances." lightbox="media/join/license-type-in-extension.png":::
  7. Select Create.

PowerShell

To install Azure extension for SQL Server, run:

$Settings = @{ SqlManagement = @{ IsEnabled = $true }; ExcludedSqlInstances = @(<Comma separated names of SQL Server instances, eg: "MSSQLSERVER01","MSSQLSERVER">); LicenseType="<License Type>"}

New-AzConnectedMachineExtension -Name "WindowsAgent.SqlServer" -ResourceGroupName {your resource group name} -MachineName {your machine name} -Location {azure region} -Publisher "Microsoft.AzureData" -Settings $Settings -ExtensionType "WindowsAgent.SqlServer"

Azure CLI

To install Azure extension for SQL Server for Windows Operating System, run:

az connectedmachine extension create --machine-name "{your machine name}" --location "{azure region}" --name "WindowsAgent.SqlServer" --resource-group "{your resource group name}" --type "WindowsAgent.SqlServer" --publisher "Microsoft.AzureData" --settings "{\"SqlManagement\":{\"IsEnabled\":true}, \"LicenseType\":\"<License Type>\", \"ExcludedSqlInstances\":[]}"

To install Azure extension for SQL Server for Linux operating system, run:

settings="{\"SqlManagement\":{\"IsEnabled\":true},\"LicenseType\":\"<License Type>\"}"
az connectedmachine extension create --machine-name "{your machine name}" --location "{azure region}" --name "LinuxAgent.SqlServer" --resource-group "{your resource group name}" --type "LinuxAgent.SqlServer" --publisher "Microsoft.AzureData" --settings $settings

The possible licensing types that you can set are:

  • PAYG
  • Paid
  • LicenseOnly

Azure extension for SQL Server for Linux is available for preview.

Once installed, the Azure extension for SQL Server recognizes all the installed SQL Server instances and connects them with Azure Arc.

The extension runs continuously to detect changes in the SQL Server configuration. For example, if a new SQL Server instance is installed on the machine, the extension automatically detects and registers it with Azure Arc. See virtual machine extension management for instructions on how to install and uninstall extensions to Azure connected machine agent using the Azure portal, Azure PowerShell or Azure CLI.

Validate your Arc-enabled SQL Server resources

Go to Azure Arc > SQL Server and open the newly registered Arc-enabled SQL Server resource to validate.

:::image type="content" source="media/join/validate-sql-server-azure-arc.png" alt-text="Screenshot of validating a connected SQL Server." lightbox="media/join/validate-sql-server-azure-arc.png":::

[!INCLUDE manage-extension]

Related content