Skip to content

Latest commit

 

History

History
71 lines (47 loc) · 3.64 KB

automatically-connect.md

File metadata and controls

71 lines (47 loc) · 3.64 KB
title description author ms.author ms.reviewer ms.date ms.service ms.custom ms.topic
Automatically connect your SQL Server to Azure Arc
Automatically connect an instance of SQL Server to Azure Arc. Allows you to manage SQL Server centrally, as an Arc-enabled resource.
anosov1960
rajpo
mikeray, maghan
07/18/2023
sql
ignite-2023
conceptual

Automatically connect your SQL Server to Azure Arc

[!INCLUDE sqlserver]

This article explains how to connect your SQL Server instance to Azure Arc.

[!INCLUDE azure-vmware]

Before you proceed, complete the Prerequisites.

Steps

  1. Onboard the server to Azure Arc
  2. Wait approximately 10 minutes
  3. [Verify your [!INCLUDE ssazurearc] resources](#verify-your-resources)

Onboard the server to Azure Arc

To connect your SQL Server to Azure, see Azure Connected Machine agent deployment options.

Note

If your server is already connected to Azure, but Azure extension for SQL Server is not deployed automatically using above methods, proceed to Alternate deployment options for SQL Server enabled by Azure Arc to connect SQL Server to Azure.

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. These provide a centralized management platform for all your SQL Server instances.

To learn more, see Auto deployment of Azure extension for SQL Server.

Verify your resources

In Azure portal, 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.":::

Note

After connecting the server to Arc, you need to wait 10 minutes for the Azure extension for SQL Server to deploy and the Arc-enabled SQL Server resource to be created.

If the Arc-enabled SQL Server resource does not appear in the same resource group as the Arc Server, follow the Azure extension for SQL Server guide to troubleshoot the issue.

Use this page in the portal to review current information about a [!INCLUDE ssazurearc]. For example:

  • The last time usage data is uploaded to Azure
  • Azure extension for SQL Server version
  • Provisioning state
  • Automatic upgrade status
  • The last time that inventory was reported

Evaluate on an Azure VM

Normally, you wouldn't use [!INCLUDE ssazurearc] on an Azure virtual machine. However, you can use an Azure SQL Virtual machine to evaluate Arc-enabled SQL Server on an Azure VM.

To test Arc-enabled SQL Server on an Azure VM, follow the steps at Evaluate Arc-enabled servers on an Azure virtual machine. For the Azure VM image, use an available Azure SQL VM image.

Related content