Release notes - Azure Arc enabled SQL Server (Preview)
No breaking changes
A new property LicenseType has been added to the SQL Server - Azure Arc resource type. It indicates if your SQL Server instance requires a license. The property can have one of the following values:
|Paid||Indicates that the SQL instance uses Enterprise, Standard or Web edition of SQL Server|
|Free||Indicates that the SQL instance uses Express or Developer edition of SQL Server|
|HADR||Indicates that the SQL instance is a replica in an availability group. If it is covered by Software Assurance, it may not require a license. For more information, see SQL Server Commercial Licensing Terms.|
For the existing SQL Server - Azure Arc resources, this property will show a Null value. It will be automatically updated with the correct value after Azure Arc enabled SQL Server becomes generally available.
This release introduces an updated resource provider called
Microsoft.AzureArcData. Before you can continue using Azure Arc enabled SQL Server, you need to register this resource provider. See the resource provider registration instructions in the Prerequisites section.
If you have existing existing SQL Server - Azure Arc resources, use these steps to migrate them to Microsoft.AzureArcData namespace.
Upload the script to the shell using the following command:
curl https://raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/manage/azure-arc-enabled-sql-server/migrate-to-azure-arc-data.ps1 -o migrate-to-azure-arc-data.ps1
Run the script.
- To paste the commands into the shell, use
Ctrl-Shift-Von Windows or
curlcommand will copy the script directly to the home folder associated with your Cloud Shell session.
- The script will prompt for the resource group name and print a message when migration is completed.
- The TCPPorts property in the SQL Server - Azure Arc resource type has been renamed to TCPStaticPorts
- The permissions required aren’t as broad as they used to be. See the Required permission section for details.
- The CreateTime property won’t be added to any newly created resources in the AzureArcData namespace, including the SQL Server - Azure Arc resources.
The October update includes the following improvements:
The register Azure Arc enabled SQL Server blade now includes the Tags tab. The tags are included in the registration script and are reflected in the SQL Server - Azure Arc resource(s). For details, see Connect your SQL Server to Azure Arc.
The Environment Health entry now supports activation of SQL Assessment from the Portal by deploying a CustomScriptExtension. For details, see Configure SQL Assessment.
The following issues apply to the October release:
- Connecting SQL Server instances to Azure Arc requires an account with a broad set of permissions. For details, see Required permissions.
Azure Arc enabled SQL Server is released for public preview. Azure Arc enabled SQL Server extends Azure services to SQL Server instances hosted outside of Azure in the customer’s datacenter, on the edge or in a multi-cloud environment.
For details, see Azure Arc enabled SQL Server Overview
The following issues apply to the September release:
The Register Azure Arc enabled SQL Server blade does not support configuring custom tags. To add custom tags, open the SQL Server - Azure Arc resource after registration and change Tags in the Overview page.
Connecting SQL Server instances to Azure Arc requires an account with a broad set of permissions. For details, see Required permissions.
Just want to try things out? Get started quickly with Azure Arc enabled SQL Server Jumpstart.