Deploy Azure SQL Managed Instance with SharePoint Servers 2016 and 2019

APPLIES TO: no2013 yes2016 yes2019 noSharePoint Online

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.

Important

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.

Environment

  1. 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.

  2. 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.

  3. Install SharePoint Server 2016 or SharePoint Server 2019 in VM 2:

    • Run PrerequitsiteInstaller.exe

    • Run Setup.exe

    • Install the May 2019 sts core patch for SharePoint Server 2016, KB 4464549 or SharePoint Server 2019, KB 4464556

    • Install the April 2019 wssloc MUI/language pack patch for SharePoint Server 2016, KB 4461507 or for SharePoint Server 2019, KB 4462221

    Note

    You can join other VMs to Active Directory in subnet 1.

  4. Create an Azure SQL Managed Instance in subnet 2, within this resource group (ManagedInstance).

    Important

    No other resources can reside in subnet 2 except for SQL MI.

  5. 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> 
    

    Where:

    • <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.
  6. Run the SharePoint Products Configuration Wizard to complete the configuration. Next open Central Administration to complete the Farm Configuration Wizard.

Note

Access Services isn't supported with Azure SQL Managed Instances.

See also

Other Resources

Azure SQL Database managed instance

SQL Server instance migration to Azure SQL Database managed instance

Quickstart: Create an Azure SQL Database managed instance

Quickstart: Configure Azure VM to connect to an Azure SQL Database Managed Instance

Quickstart: Restore a database to a Managed Instance