Updated: October 23, 2023 (October 9, 2023)

Arc-Enabled SQL Server Management Feature Comparison

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

Arc-enabled SQL Server provides access to features that help manage SQL Server outside of Azure; however, available features depend on several factors. The chart shows which Arc-related features and services (on the left) that are available based on the following:

SQL Server version – it supports all versions still in support, currently 2012 – 2022
License type assigned – license with or without Software Assurance (Sa) and Pay-as-you-go (PAYG) licensing which includes SA
Hosting OS – SQL Server is available on currents Windows versions and Linux

As the chart shows, only SQL Server 2022, licensed with Software Assurance (SA), and deployed on Windows has access to all the features.

Some of the capabilities are available without Arc (far right column); however, those features are more automated and faster to deploy when using Arc, because the service provides prebuilt connections and can execute the features simultaneously across multiple instances.

Finally, some features, such as Microsoft Purview, Defender for SQL, and Entra ID integration require setting up other Azure services and incur additional cost.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now