Forum Discussion
Solved
Does SharePoint Workflow Manager support SQL 2016?
Bill Baer, jcgonzalezmartin: SP2016 uses the same workflow Manager as SP2013 which supported SQL 2012.
Does the workflow Manager support the newly released SQL 2016?
Just an update on the support for Workflow Manager 1.0
SQL 2016 is not supported for WFM
SQL 2014 is supported but only for SharePoint based scenarios (SharePoint 2016 supports WFM 1.0 CU3 and SB1.1)
SQL 2012 is supported for all scenarios
There is no active development to support SQL2016
Well I think its time to celebrate now, finally SharePoint 2016, Windows 2016 and SQL 2016 are in the compatibility list for Workflow Manager.
Check this post - https://blogs.msdn.microsoft.com/workflowteam/2017/07/25/workflow-manager-1-0-now-supported-on-windows-server-2016-with-cu4/
Best regards,
Riwut L
That last link was broken, the correct link is https://blogs.msdn.microsoft.com/workflowteam/2017/07/25/workflow-manager-1-0-now-supported-on-windows-server-2016-with-cu4/
According to this blog post https://blogs.msdn.microsoft.com/workflowteam/2017/07/25/workflow-manager-1-0-now-supported-on-windows-server-2016-with-cu4/ CU4 does support SQL Server 2016
Yes it does support. I have successfully installed Workflow Manager 1.0 on SharePoint Server 2016 which was using SQL 2016 as DB server. Make sure you install all the latest patches on SharePoint Server and SQL 2016 and the most important you must download and install is the latest CU for Workflow Manager and Service Bus.
I am able to create SharePoint 2013 workflow through SharePoint Designer 2013 without any issues on my SharePoint 2016 with SQL 2016 as DB server.
- Installing it successfully and supported are two different things. As of right now, it isn't supported as it isn't in the CU4 rel notes.
Trevor Seward. Please clarify what do we mean by supported here? I am able to create SP 2013 workflow and the workflow is running perfect. I have not created a single workflow but many.
- Thanks for this useful update!
Johanson SandrasagraMicrosoft
Just an update on the support for Workflow Manager 1.0
SQL 2016 is not supported for WFM
SQL 2014 is supported but only for SharePoint based scenarios (SharePoint 2016 supports WFM 1.0 CU3 and SB1.1)
SQL 2012 is supported for all scenarios
There is no active development to support SQL2016
Thanks Johanson Sandrasagra for the clarification on the current status and future plans.
It is odd that there is no active development to support SQL 2016.
In our scenario, we plan to use SQL 2016 to take advantage of the BI features. We are therefore forced to have two separate SQL installations - SQL 2016 for SharePoint Content DBs and SQL 2012 for Workflow Manager.
This setup doesn't look elegant in a production environment.
It would be good if Microsoft considered support for SQL 2016 and clarified the future of Workflow Manager. This will be useful information for organizations planning to migrate to SP2016.
Trevor Seward, wbaer, jcgonzalezmartin
- You do not need SQL 2016 Database Engine for SQL 2016 BI features. You can use SQL 2014 to support SSRS 2016. For SSAS 2016, that shouldn't be on the same box anyhow.
Expensive licensing, though. Purchasing at least 3 copies of SQL Server for at a minimum three different servers. As you can probably figure out, Workflow Manager is a deprecated piece of software. It has had no feature improvements (except for supportability updates) and the Azure team has moved on to Azure Service Bus.
- Thanks. When will this appear in TN documentation? This is slightly different than the response than other private communities have received.
- Johanson Sandrasagra
Working on getting the official documentation updated...
A support case was open and the PG engaged which confirmed SharePoint 2016 with WFM only officially supports SQL 2014 and not SQL 2016. WFM stand-alone does not support SQL 2014 and SQL 2016 - supports only SQL 2012 and SQL 2008R2.
2016 is not listed on the supported platforms page at https://msdn.microsoft.com/en-us/library/jj193487(v=azure.10).aspx,
That page has not been updated in a long time, WF Manager is not getting much attention from anyone at MS.
Joe Davies do you know anyone that can review and update the Workflow Manager documenation?
- Waiting for Bill's Baer answer :-)
- I reached out to Microsoft support. They told me that Workflow Manager doesn't support SQL 2016.
AFAIK, there is not an official support of Workflow manager with SQL 2016 but Bill Baer will confirm this for sure
- wbaer
WFM only officially supports SQL 2014 and not SQL 2016. WFM stand-alone does not support SQL 2014 and SQL 2016 - supports only SQL 2012 and SQL 2008R2. Refer to https://msdn.microsoft.com/en-us/library/jj193487(v=azure.10).aspx.
Hope this helps!
Bill
