Azure Arc enabled SQL Server is now in public preview. It extends Azure services to SQL Server instances deployed outside of Azure in the customer’s datacenter, on the edge or in a multi-cloud environment.
The preview includes the following features:
- Use Azure Portal to register and track the global inventory of your SQL instances across different hosting infrastructures. You can register an individual SQL instance or register a set of servers at scale using the same auto-generated script.
- Use Azure Security Centerto produce a comprehensive report of vulnerabilities in SQL servers and get advanced, real time security alerts for threats to SQL servers and the OS.
- Periodically check the health of the SQL Server configurations and provide comprehensive reports and remediation recommendations using the power of Azure Log analytics.
The following diagram illustrates the architecture of Azure Arc enabled SQL Server
The SQL Server can be installed in a virtual or physical machine running Windows or Linux that is connected to Azure Arc via the Connected Machine agent. The agent is installed and the machine is registered automatically as part of the SQL Server instance registration. The agent maintains secure communications with Azure Arc over an outbound port 443 directly or via a HTTP proxy. Any SQL Server instance version 2012 or higher can be registered with Azure Arc.
How to get started
Check out Azure Arc enabled SQL Server documentation for more details on how to register and manage your SQL Server instances using Azure Arc.