Installing the Power Pivot Service

Apr 4, 2012 at 4:30 PM

Sorry to bring up an old discussion but It was never answered. I was wondering how to configure power pivot after installing the prereqs.

From old poster thekeel

"Once the farm is installed the front page says to rerun the script after installing POWERPIVOT:

PowerPivot Service Application (Note: For this one, you'd need to first install your farm, then install the PowerPivot component for SQL2008 R2, then re-run the script with <CreatePowerPivot> set to 1)

Not seeing the <CreatePowerPivot> tags in the script.  Is that something I just need to add in there, and if so, just anywhere?"

thanks,

Apr 9, 2012 at 5:30 PM

I'd like to see a PowerPivotService install also. I found this power shell script to do it but haven't actually tried it yet and wouldn't have the skills to add it to AutoSPInstaller. http://kellydjones.com/archive/2011/09/18/146931.aspx.

Any comments about Kelly Jones' script would be helpful.

Thanks!