Forum Discussion
Does SharePoint Workflow Manager support 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
MicrosoftJust 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.- I'm not so sure SQL Server 2016 is not a requirement for SharePoint 2016 BI Features. The documentation released during the preview (I don't know if there is an update for the RTM) just stated the opposite. On the other hand, I'm not a SSRS specialist, but bearing in mind SSRS 2016 comes with many changes I'm not so sure you can deploy it on top of SQL Server 2014
- You can use SSRS 2016 with SQL 2014 DB Engine. Excel 2016 has some new DAX features that do not support SSAS 2016, but if you can live without them, you can continue using SSAS 2014 (a PowerPivot 2014 instance). Nearly all SSRS 2016 changes are only for native mode, SSRS 2016 integrated mode really didn't get much but a UI upgrade.
