Share via

SharePoint 2016, SQL 2016 and licensing

  • Article

Hello All,

This is currently not meant to be an exhaustive article, but more of a foot note in my research of SharePoint 2016.  I was recently asked what would be the functionality lose to the BI Stack if a customer installed SQL 2016 Standard license, and so began the chase.

Spoke with many people and was pointed to many vague articles but in the end all the answers were here.

If you install SQL 2016 Standard license with SharePoint 2016 you will not be able to use PowerPivot for SharePoint, it turns out that this requires that the SSAS be installed on SQL 2016 Enterprise.  Which means that you could add this as a phase 2 if you wanted to.

Articles of Interest:

Install or Uninstall the Power Pivot for SharePoint Add-in (SharePoint 2016) Example of a Minimum-Privilege Configuration for Power Pivot for SharePoint 2016 Configure Power Pivot and Deploy Solutions (SharePoint 2016) Deploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm Reporting Services Report Server

Pax