Oct 12 2016 12:52 AM
@Bill Baer, @Juan Carlos González Martín: SP2016 uses the same workflow Manager as SP2013 which supported SQL 2012.
Does the workflow Manager support the newly released SQL 2016?
Oct 12 2016 12:56 AM
AFAIK, there is not an official support of Workflow manager with SQL 2016 but @Bill Baer will confirm this for sure
Oct 12 2016 05:41 AM
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?
Oct 12 2016 07:07 AM
Oct 15 2016 12:00 AM
Oct 15 2016 03:40 AM
Oct 15 2016 10:44 PM
Reference:
https://msdn.microsoft.com/en-us/library/jj193487(v=azure.10).aspx
and
https://gallery.technet.microsoft.com/office/SharePoint-2016-Workflow-acd5ba2a
Note:
SQL Server 2014 with SP1 is now supported with workflow manager 1.0 farm topology only if all the servers in the workflow farm are patched with the CU2
Oct 15 2016 11:41 PM
Nov 08 2016 03:02 PM
SQL Server 2014 is currently not officially supported by Microsoft; as you can see, that PDF wasn't written by a Microsoft employee. The MSDN documentation is currently correct - SQL 2012 is the highest version supported.
Nov 10 2016 08:53 AM
SolutionJust 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
Nov 10 2016 08:56 AM - edited Nov 10 2016 08:57 AM
Nov 10 2016 09:21 AM
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.
Nov 10 2016 01:07 PM
Nov 12 2016 09:46 AM
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, @Bill Baer, @Juan Carlos González Martín
Nov 12 2016 09:49 AM
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
Nov 12 2016 09:49 AM
Nov 12 2016 09:59 AM
Nov 12 2016 10:01 AM
Nov 18 2016 09:50 AM
Bill, We have two separate farms supported by SQL 2016 and on both farms WFM running. So, are you saying we should stop using not supported version?
Nov 23 2016 06:55 AM
What about Windows Server support, WFM is not supported on Windows Server 2016 correct? @Bill Baer @Johanson Sandrasagra
Nov 10 2016 08:53 AM
SolutionJust 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