Does Workflow for SharePoint hosted in Azure VM support use of Azure Managed SQL instance?

James Whitlock 5 Reputation points
2023-12-19T17:01:10.8833333+00:00

We are moving our SharePoint Subscription Edition to the Azure cloud as an On-Prem farm. We also us Workflow for SharePoint and have concerns that Workflow for SharePoint DOES NOT support the use of Azure Managed SQL instances rather than Azure VM's running SQL with Always on Availability Groups.

Azure SQL Database
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
569 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 25,301 Reputation points Microsoft Vendor
    2023-12-20T06:19:03.3766667+00:00

    Hi @James Whitlock ,

    You can deploy SharePoint Server Subscription Edition with 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. However, 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.

    Regarding your concern about Workflow for SharePoint, I couldn’t find any information that suggests that Workflow for SharePoint does not support the use of Azure Managed SQL instances. Please pay attention to Microsoft's official website to obtain the latest information on this matter. I will continue to pay attention and any news will be shared here in a timely manner.

    For your reference:

    Best practices for SQL Server in a SharePoint Server farm

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.