Edit

Alternate deployment options for SQL Server enabled by Azure Arc

  • Article

Applies to: SQL Server

Important

Azure Arc automatically installs the Azure extension for SQL Server when a server connected to Azure Arc has SQL Server installed. All the SQL Server instance resources are automatically created in Azure, providing a centralized management platform for all your SQL Server instances. To automatically connect your SQL Server instances, see Automatically Connect your SQL Server to Azure Arc. Use the methods below, if your server is already connected to Azure, but Azure extension for SQL Server is not deployed automatically using above methods.

Connecting machines in your hybrid environment directly with Azure can be accomplished using different methods, depending on your requirements and the tools you prefer to use.

Tip

Beginning with SQL Server 2022, you can connect a new SQL Server instance to Azure Arc when you're installing it on Windows Operating System. Install SQL Server 2022.

Onboarding methods

The following table highlights each method so that you can determine which works best for your deployment. For detailed information, follow the links to view the steps for each topic.

Method Description
Interactively Manually connect the SQL Server instance on a single physical or virtual machine. Connect your SQL Server to Azure Arc
Interactively Connect your SQL Server to Azure Arc with installer (.msi)
Interactively Manually connect the SQL Server on a single physical or virtual machine that is already connected to Azure Arc. Connect your SQL Server to Azure Arc on a server already connected to Azure Arc
At scale Automatically enable SQL Server for Azure Arc
At scale Connect SQL Server at scale using Azure policy (deprecated - use Automatically connect your SQL Server to Azure Arc)
At scale Connect SQL Server at scale using script
At scale Connect SQL Server machines at scale with a Configuration Manager custom task sequence

Be sure to review the basic prerequisites before you deploy the agent, as well as any specific requirements listed in the steps for the onboarding method you choose.

Next steps

  • Learn about the Azure Connected Machine agent and network requirements in prerequisites