Alternate deployment options for SQL Server enabled by Azure Arc
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