Edit

Share via


Deployment options for SQL Server enabled by Azure Arc

Applies to: SQL Server

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 server, see Azure Connected Machine agent deployment options.

If your server is already connected to Azure, but Azure extension for SQL Server did not deploy automatically.

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 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 machines at scale by running PowerShell scripts with Configuration Manager
At scale Connect 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