Skip to main content

Posts

Showing posts from August, 2012

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 this would re