we are in process of installing power pivot and BI services in SharePoint 2013.

Does it have to be installed on SharePoint 2013 itself box where SharePoint 2013 is installed or it should be installed on separate SQL server or analysis server ?

we have already sql 2014 server enterprise license and SharePoint 2013 enterprise edition and we have around 850 users who uses SharePoint 2013 and 200 users will be using SharePoint 2013 BI features (Power Pivot, SSRS, Excel Services, Power View).

we are trying to save licensing cost of sql server so better to know it.

Suggest a best way to utilize sql resources to minimize sql licensing cost.

Thanks,

Deepak patel

SSRS must be installed on one or more SharePoint servers. The PowerPivot SSAS instance can be installed on a SharePoint server, or preferably a dedicated server for PowerPivot. You will still need to install the PowerPivot System Service (http://www.microsoft.com/en-us/download/details.aspx?id=42300) on one or more SharePoint servers, but there is no licensing cost.

You might want to contact Microsoft Licensing to see where the break point is for the Business Intelligence vs. Enterprise editions of SQL.