Skip to main content

Posts

Showing posts with the label SharePoint 2010

Microsoft PowerPivot Configuration tool uses MSMDSRV.INI to see if PowerPivot System Service is installed

With SQL Server 2012 Microsoft released a new tool to help integrating  PowerPivot into the SharePoint environment. This tool - PowerPivot Configuration Tool - register among others the PowerPivot System Service on the local computer and creates the cube for the PowerPivot Management Console.  Besides all that it creates a SharePoint Library on the SharePoint Central Administration site with PowerPivot Excel files for each available language. These file connects to a central PowerPivot Excel file that acts as a kind of hub for the data stored in the PowerPivot Management Console cube on Analysis services. Recently I had some issues with an installation of PowerPivot. The PowerPivot Management Console gave a red cross, and though this feature is well documented on powerpivotgeek.com this did not work for me. I think due to the fact that my installation is on SQL Server 2012.  So I deleted the Default PowerPivot Service Application and created a new one hoping that...