Deploy Azure SQL Managed Instance with SharePoint Servers 2016 and 2019
SharePoint Servers 2016 and 2019 now support Azure SQL Managed Instance (MI). SQL MI is a deployment option of Azure SQL Database and is compatible with the current version of SQL Server (on-premises), Enterprise Edition Database Engine.
SharePoint Server farms must be hosted in Microsoft Azure to support Azure SQL Managed Instance. The SharePoint Server farm and the managed instance must be hosted in the same Azure region. SharePoint Server farms don't support managed instances when hosted in customer datacenters.
Deploying a managed instance with SharePoint Server lets you move your SQL Server on-premises application to the cloud with little or no application and database changes. The following procedure shows how to deploy an Azure SQL Database Managed Instance with SharePoint Servers 2016 and 2019.
Create a resource group with a vNet and then create two subnets. You can use the SQL Managed Instance Virtual Network Environment template to create an Azure Virtual Network with two subnets.
Create subnet 1 (Default) and then create two VMs. First, set up VM 1 as an Active Directory Directory Services domain controller and configure your domain. For more information, see Step-By-Step: Setting up Active Directory in Windows Server 2016.
Install SharePoint Server 2016 or SharePoint Server 2019 in VM 2:
You can join other VMs to Active Directory in subnet 1.
Create an Azure SQL Managed Instance in subnet 2, within this resource group (ManagedInstance).
No other resources can reside in subnet 2 except for SQL MI.
Create the SharePoint farm, hosting the databases on SQL MI with SQL authentication. Open the SharePoint Management Shell and run the following Windows PowerShell commands:
$FarmCredential = Get-Credential -Message "Provide the user name and password for the SharePoint farm service account." $DBCredential = Get-Credential -Message "Provide the user name and password for the Azure SQL Managed Instance database login." $FarmPassphrase = Read-Host -AsSecureString -Prompt "Provide the SharePoint farm passphrase" New-SPConfigurationDatabase -DatabaseServer <DBServer> -DatabaseName <ConfigDB> -FarmCredentials $FarmCredential -DatabaseCredentials $DBCredential -Passphrase $FarmPassphrase -LocalServerRole <ServerRole>
- <DBServer> is the name you gave the Azure SQL Managed Instance in step 4.
- <ConfigDB> is the name of the SharePoint configuration database to be created.
- <ServerRole> is the SharePoint MinRole server role for this server in the SharePoint farm.
Run the SharePoint Products Configuration Wizard to complete the configuration. Next open Central Administration to complete the Farm Configuration Wizard.
Access Services isn't supported with Azure SQL Managed Instances.