Forum Discussion

Gilbert Okello's avatar
Gilbert Okello
Iron Contributor
Oct 12, 2016
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?    
2016
sharepoint server
  • Johanson Sandrasagra's avatar
    Johanson Sandrasagra
    Nov 10, 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

Gilbert Okello's avatar
Gilbert Okello
Iron Contributor
Oct 15, 2016
I reached out to Microsoft support. They told me that Workflow Manager doesn't support SQL 2016.
  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Oct 15, 2016
    Thanks for the official confirmation :-)
    • Gilbert Okello's avatar
      Gilbert Okello
      Iron Contributor
      Oct 16, 2016

      Reference:

      https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fjj193487(v%3Dazure.10).aspx&data=01%7C01%7CGilbert.Okello%40steeves.net%7C1f06f8bd2ca14546b48b08d3f44e2793%7Cbcbc65a5a89a4127afa24989e539f462%7C1&sdata=NXC0ZurbK7GyBccgYjORmqg4Uo9iozLzN6VRaWV%2BArU%3D&reserved=0

      and 

      https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgallery.technet.microsoft.com%2Foffice%2FSharePoint-2016-Workflow-acd5ba2a&data=01%7C01%7CGilbert.Okello%40steeves.net%7C25265315b2b841b577d008d3f3b619d2%7Cbcbc65a5a89a4127afa24989e539f462%7C1&sdata=lPMsM0y4U11eDX1gDbJdje1bXeHoqxdtLIZofePFTjM%3D&reserved=0

       

      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

       

      • Trevor Seward's avatar
        Trevor Seward
        MVP
        Nov 08, 2016

        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.

Resources