Deploy SharePoint Server with Azure SQL Managed Instance
APPLIES TO: 2013 2016 2019 Subscription Edition SharePoint in Microsoft 365
SharePoint Server 2016, SharePoint Server 2019, and SharePoint Server Subscription Edition 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 data centers.
Deploying SharePoint Server with an Azure SQL Managed Instance 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 SharePoint Servers 2016, 2019, or Subscription Edition with an Azure SQL Managed Instance.
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 or SharePoint Server Subscription Edition in VM 2:
If you're using SharePoint Server 2016 or SharePoint Server 2019, Install the April 2019 (or newer) wssloc MUI/language pack patch for SharePoint Server 2016 (KB 4461507) or for SharePoint Server 2019 (KB 4462221).
You can join other VMs to Active Directory in subnet 1.
No updates need to be installed for SharePoint Server Subscription Edition.
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 or join the SharePoint farm, hosting the databases on SQL MI with SQL authentication.
To create the SharePoint farm, 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>
To join additional VMs to the SharePoint farm, open the SharePoint Management Shell on the additional VMs and run the following Windows PowerShell commands:
$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" Connect-SPConfigurationDatabase -DatabaseServer <DBServer> -DatabaseName <ConfigDB> -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.
SharePoint Server doesn't support connecting to databases hosted in Azure SQL Managed Instance using Windows authentication.
Access Services isn't supported with Azure SQL Managed Instance.