SharePoint 2016, SQL 2016 and licensing
Published May 15 2019 03:12 PM 402 Views

First published on TECHNET on Aug 25, 2016
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


Version history
Last update:
‎Apr 28 2020 03:21 PM
Updated by: