Workflow Manager Support for SQL 2014 with a SharePoint Farm

  • Article

This post contains information for Workflow Manager CU3. Please see KB4019220 for information workflow manager CU4.  https://support.microsoft.com/en-us/help/4019220/description-of-the-cumulative-update-4-for-workflow-manager-1-0

With SharePoint 2016 supporting a minimum of SQL Server 2014 Service Pack 1, many customers have asked if they need a separate SQL Server 2012 instance for the Workflow Manager farm that supports their SharePoint installation. This post is to clarify the support for SQL versions and high availability features when Workflow Manager is used with a SharePoint farm.

 

SQL Version Support

When Workflow Manager is deployed for use with only a SharePoint 2016 or 2013 farm, SQL 2014, SQL 2012 and SQL 2008 R2 SP1 are supported for the database engine hosting the Workflow Manager and Service Bus databases. SQL 2014 support requires requires Workflow Manager 1.0 with CU3, Service Bus 1.1, and KB3086798. Information on supported service packs for SQL Server 2014 can be found on the Microsoft Product Support Lifecycle page.

If Workflow Manager is being used for any other purpose, only SQL 2012 and SQL 2008 R2 SP1 are supported as per Supported Platforms (Workflow Manager 1.0).

 

SQL High Availability Feature Support

For high availability in a single farm Workflow Manager supports either SQL Failover Clustering or Synchronous Mirroring. AlwaysOn Availability Groups are not supported.

 

Resources

Workflow Manager 1.0 Cumulative Update 3 (WFM CU3) is now available on Microsoft Download Center
https://blogs.msdn.microsoft.com/workflowteam/2016/01/25/workflow-manager-1-0-cumulative-update-3-wfm-cu3-is-now-available-on-microsoft-download-center/

An update is available for Service Bus for Windows Server 1.1 for the .NET Framework 4.6 (KB3086798)
https://support.microsoft.com/en-us/kb/3086798

Supported Platforms (Workflow Manager 1.0)
https://msdn.microsoft.com/en-us/library/jj193487(v=azure.10).aspx

Disaster Recovery and Scope Restore in Workflow Manager 1.0
https://technet.microsoft.com/en-us/library/jj730570.aspx

Hardware and software requirements for SharePoint Server 2016
https://technet.microsoft.com/en-us/library/cc262485(v=office.16).aspx