Category: sql server powerpivotsp
kathrynsharepoint on Mon, 17 Dec 2012 18:03:53
We first installed SharePoint 2013 with a SQL Server 2012 SP1 Standard backend and then decided to upgrade the edition to SQL Server 2012 SP1 Business Intelligence, which we did with no problem.
After the edition upgrade when we try to install Analysis Services in SharePoint Mode, there is no option to in the Installation Center to add "Analysis Services in SharePoint Mode" to our default MSSQLSERVER instance.
It appears that the only way we can get it on is to "Perform a new installation of SQL Server 2012", which is not what we want since we don't what two instances of "Database Engine Services" on the server. And even this doesn't seem to really work because choose a new installation defaults to the MSSQLSERVER instance name but won't let you proceed with this name, since, obviously, the instance name should be POWERPIVOT. (see screenshots)
So it seems like the edition upgrade has confused the installer software.
We can't uninstall the default instance and start all over again since we already have SharePoint databases on the default "MSSQLSERVER" instance.
Does anybody know a way out of this? Some PowerShell commands perhaps?
Elvis Long on Thu, 20 Dec 2012 09:32:37
Please select "SQL Server PowerPivot for SharePoint" option and go ahead to configure Analysis Services with SharePoint. Here are some articles about the configuration for your reference, please see:
Install Analysis Services Server in SharePoint Mode for SharePoint 2013 (SQL Server 2012 SP1): http://technet.microsoft.com/en-us/library/d3310562-82c1-454f-9c48-33a241749238
Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1): http://technet.microsoft.com/en-us/library/jj218795.aspx
kathrynsharepoint on Thu, 20 Dec 2012 19:32:02
The default instructions don't work because I only want to ADD a PowerPivot analysis services instance to an ALREADY EXSITING DEFAULT DATABASE instance and the installer won't let me do this. It wants to create ANOTHER daatabase instance.
Ivan Sanders on Sat, 29 Dec 2012 21:30:00
If you go to the SQL Server installation Center or the first screen that pops up and Click on Tools > Installed SQL Server Features discovery report. It should look something like this... As you can see I have the default instance and a PowerPivot database instance
However, if I uncheck the Add SQL Server Database Relational Engine as in the following screen capture
AS you can see from the Feature Section screen capture below the Database Engine e Features are no longer listed...