A couple of months ago Microsoft announced a new Hybrid Cloud feature called Azure Arc enabled SQL Server. Azure Arc enabled SQL Server allows you to manage your global inventory of SQL servers, protect SQL Server instances with Azure Security Center or periodically assess and tune the health of your SQL Server configurations. In this blog post, we will cover how you can add SQL Server to Azure Management using Azure Arc.

Azure Arc enabled SQL Server Architecture

Azure Arc enabled SQL Server Architecture

Prerequisites

Before you add an Azure Arc enabled SQL Server, you need to prepare the following prerequisites:

  • A virtual or physical machine running SQL Server. The machine hosting SQL Server must be connected to the internet directly or via a proxy server. Running one of the following operating systems:
    • Windows Server 2012 R2 and higher
    • Ubuntu 16.04 and 18.04 (x64)
    • CentOS Linux 7 (x64)
    • SUSE Linux Enterprise Server (SLES) 15 (x64)
  • The Connected Machine agent communicates outbound securely to Azure Arc over TCP port 443. If the machine connects through a firewall or a HTTP proxy server to communicate over the Internet, review the network configuration requirements for the Connected Machine agent.
  • A user account with permissions (An user account with local admin rights.
  • Azure PowerShell installed on the computer executing the onboarding script.
  • You need to have the “Microsoft.AzureData” provider namespace registered. You can run the following Azure PowerShell command to do that: “Register-AzResourceProvider -ProviderNamespace Microsoft.AzureData”. You can run that command in Azure Cloud Shell.

To learn more about the prerequisites, check out the following Microsoft Docs page.