Upgrade SQL Server BI Features to SQL Server 2012 SP1

This topic describes the upgrade of SQL Server Business Intelligence features to SQL Server 2012 Service Pack 1 (SP1). SQL Server 2012 SP1 is available as two installation packages; update and slipstream. This topic describes the corresponding workflows for these two installation packages to upgrade SQL Server Business Intelligence features. To download the SQL Server 2012 SP1 installation packages, see Microsoft® SQL Server® 2012 Service Pack 1 (SP1) (https://www.microsoft.com/en-us/download/details.aspx?id=35575).

  • Update: Run the SQL Server 2012 SP1 Update package to apply the delta between SQL Server 2012 and SQL Server 2012 SP1 on existing SQL Server 2012 installations. The update package cannot be used to upgrade SQL Server 2008 or SQL Server 2008 R2 or to perform a new installation of SQL Server 2012.

    Example file name of an update package:

    SQLServer2012SP1-KB2674319-x64-ENU.exe

  • Slipstream: Run the SQL Server 2012 SP1 slipstream package to install new SQL Server 2012 instances without first having to install SQL Server 2012. The slipstream package also supports upgrading an existing SQL Server 2008 and SQL Server 2008 R2 installations.

    Example file name of a slipstream package:

    SQLServer2012SP1-FullSlipstream-x64-ENU.exe

In this topic:

  • SQL Server Analysis Services

  • SQL Server Reporting Services

  • SQL Server 2012 SP1 Download links

  • Installation Package User Interface Reference

SQL Server Analysis Services

An Analysis Services server instance runs in one of three deployment modes. The following table summarizes how the SQL Server 2012 SP1 installation packages update Analysis Services depending on the deployment mode. The PowerPivot deployment mode is listed twice to differentiate the experience and installation with SharePoint 2010 and SharePoint 2013.

Note: With SQL Server 2012 SP1, PowerPivot for SharePoint supports separate architectures for SharePoint 2010 and SharePoint 2013. The new PowerPivot architecture for SharePoint 2103 includes an Analysis Services server deployed outside the SharePoint farm. The new architecture applies only to SharePoint 2013 and not SharePoint 2010. The architecture of PowerPivot for SharePoint 2010 remains unchanged. In this topic, the phrase “original architecture” refers to an Analysis Services server in SharePoint mode, installed by using the SQL Server 2012 installation media. The original SQL Server 2012 Analysis Services server has the version 11.0.2100. SQL Server 2012 SP1 updates the Analysis Services components to version 11.0.3000. You can verify the version of the Analysis Services service on the advanced properties tab in SQL Server Configuration Manager.

 

Deployment Mode

Comments

Multidimensional and Data Mining (default)

Update Package: Run the update package on an existing deployment of SQL Server 2012.

Slipstream package: Run the slipstream package to complete one of the following:

  • Update an existing SQL Server 2012 deployment.

  • Upgrade an existing 2008 or 2008 R2 deployment to SQL Server 2012 SP1.

  • Install a new instance of SQL Server 2012 SP1.

Tabular

Update Package: Run the update package on an existing deployment of SQL Server 2012.

Slipstream package: Run the slipstream package to complete one of the following:

  • Update an existing SQL Server 2012 deployment.

  • Upgrade an existing 2008 or 2008 R2 deployment to SQL Server 2012 SP1.

  • Install a new instance of SQL Server 2012 SP1.

PowerPivot for SharePoint 2010

Update Package: Run the update package on an existing deployment of SQL Server 2012 and then run the PowerPivot Configuration Tool for SharePoint 2010. The package updates the SQL Server 2012 Analysis Services instance that is running in SharePoint mode.

The PowerPivot configuration tool updates the PowerPivot solution files in SharePoint. Repeat the update procedures on all SharePoint servers that are running PowerPivot Services.

Important

The update package cannot install the new PowerPivot for SharePoint 2013 architecture.

Slipstream package: Run the slipstream package to complete one of the following:

  • Update an existing SQL Server 2012 PowerPivot for SharePoint 2010 deployment that is using the original PowerPivot for SharePoint architecture. Run the PowerPivot Configuration Tool for SharePoint 2010 to update the SharePoint farm.

  • Update or install other SQL Server components.

  • Install a new instance of an Analysis Services server that is running in SharePoint mode. Then run the PowerPivot Configuration tool for SharePoint 2010 to deploy the PowerPivot solution files in the SharePoint farm. The new slipstream version contains updated files for the original PowerPivot architecture as well as an updated version of the PowerPivot Configuration tool for SharePoint 2010.

PowerPivot for SharePoint 2013

Update Package: Run on an existing deployment of SQL Server 2012. The package updates the SQL Server 2012 Analysis Services instance and installs the PowerPivot for SharePoint 2013 Configuration tool. To deploy the new PowerPivot for SharePoint 2013 solution files in SharePoint, run the PowerPivot for SharePoint 2013 Configuration tool. If the SharePoint server is separate from the server that is running Analysis Services in SharePoint mode:

  1. Download the PowerPivot for SharePoint 2013 add-in (SpPowerPivot.msi) from the SQL Server 2012 SP1 feature Pack.

  2. Run the .msi on the SharePoint server.

  3. Run the PowerPivot for SharePoint 2013 Configuration tool on the SharePoint server.

Slipstream package: Run to complete one of the following:

  • Update an existing instance of 2012 Analysis Services running in SharePoint mode. Note: It is not possible to upgrade a PowerPivot for SharePoint 2010 deployment directly because SharePoint 2013 does not support in-place upgrades. However, an Analysis Services instance that is currently used for PowerPivot for SharePoint 2010 can be updated to support a new SharePoint 2013 farm.

  • Install a new instance of Analysis Services in SharePoint mode to enable Excel Services in SharePoint 2013 to load and query data.

    Note

    There can only be one Analysis Services instance named PowerPivot. Therefore, run the slipstream installation package on a server that does not already have an existing Analysis Services PowerPivot instance.

  • Update or install other SQL Server components.

SpPowerPivot.msi: To enhance the SQL Server 2012 SP1 PowerPivot for SharePoint 2013 experience, run the SpPowerPivot.msi installer package. The .msi installs data providers, SharePoint solution packages, and the PowerPivot for SharePoint 2013 Configuration tool. For more information, see Install or Uninstall the PowerPivot for SharePoint Add-in.

SharePoint 2013 does not support in-place upgrade from SharePoint 2010. You can migrate content from a SharePoint 2010 farm to a SharePoint 2013 farm. For more information on migration and a SharePoint database-attach upgrade, see the following.

See the following section for more PowerPivot for SharePoint information.

For more information on the modes of an Analysis Services server, see Determine the Server Mode of an Analysis Services Instance.

Arrow icon used with Back to Top link Top

PowerPivot for SharePoint Summary

The following table summarizes the SQL Server 2012 SP1 update and slipstream workflows related to PowerPivot for SharePoint.

2012 SP1 Installation Package

SQL Server version

SharePoint versions

Workflows

Update

SQL Server 2012

SharePoint 2010, SharePoint 2013

SQL Server Setup updates the existing Analysis Services instance and PowerPivot Configuration Tool for SharePoint 2010. It also installs the PowerPivot for SharePoint 2013 Configuration tool. Following the update, run the PowerPivot Configuration tool appropriate for your SharePoint version, to update the PowerPivot solution files in your SharePoint farm.

Slipstream

SQL Server 2008 R2

SharePoint 2010

SQL Server Setup upgrades the existing Analysis Services instance and installs the PowerPivot Configuration Tool for SharePoint 2010. Run the PowerPivot Configuration Tool to update the PowerPivot solution files in your SharePoint 2010 farm. Repeat these steps on every SharePoint server that is running PowerPivot services in the farm.

Slipstream

SQL Server 2012

SharePoint 2010

SQL Setup updates the existing Analysis Services instance and installs the PowerPivot Configuration Tool for SharePoint 2010. Run the PowerPivot Configuration Tool to update the PowerPivot solution files in your SharePoint 2010 farm. Repeat these steps on every SharePoint server that is running PowerPivot services in the farm.

Slipstream

SQL Server 2012

SharePoint 2013

Install a new instance of Analysis Services in SharePoint mode. The SQL Server 2012 SP1 slipstream package installs the new PowerPivot for SharePoint 2013 Configuration tool. Run the PowerPivot for SharePoint 2013 Configuration tool to deploy the PowerPivot solution files in your SharePoint 2013 farm. If the SharePoint server is separate from the server that is running Analysis Services in SharePoint mode:

  1. Download the PowerPivot for SharePoint 2013 add-in (SpPowerPivot.msi) from the SQL Server 2012 SP1 Feature Pack.

  2. Run the .msi on the SharePoint server.

  3. Run the PowerPivot for SharePoint 2013 Configuration tool on the SharePoint server.

Tip

For information on versions of data models, see Version compatibility between PowerPivot Data Models in Excel 2010 and Excel 2013 (https://office.microsoft.com/en-us/excel-help/version-compatibility-between-powerpivot-data-models-in-excel-2010-and-excel-2013-HA103929426.aspx).

Arrow icon used with Back to Top link Top

SQL Server Reporting Services

This section summarizes installing SQL Server 2012 SP1 and the following deployments:

  • SharePoint mode report servers

  • Native mode report servers

  • Report Builder

SharePoint mode report servers

Reporting Services SharePoint mode deployments involve two main components:

  • Application tier application servers or report server. In the current version of Reporting Services, the report server is a SharePoint service, running on SharePoint application servers along with one or more instances of a Reporting Services service application. Install the Reporting Services SharePoint mode report server from the SQL Server installation media. For more information, see Install Reporting Services SharePoint Mode for SharePoint 2013.

  • Web tier or web servers. Install the Reporting Services add-in for SharePoint products on each web server. A new version of Rssharepoint.msi released with SQL Server 2012 SP1.

    Note

    The new Rssharepoint.msi is compatible with previous versions of report servers. However, if you want to use Power View, then it is required that both the report server and the Rssharepoint.msi are the SQL Server 2012 SP1 version. For more information on installing the .msi, see Install or Uninstall the Reporting Services Add-in for SharePoint.

The following table summarizes the SQL Server 2012 SP1 update and slipstream workflows related to Reporting Services in SharePoint mode. It is recommended the report servers in your SharePoint farm are all running the same version of Reporting Services.

2012 SP1 installation package

Description

Update Package

Run the update package on application servers with an existing deployment of SQL Server 2012 Reporting Services report server in SharePoint mode.

Slipstream package

Run the slipstream package to complete one of the following:

  • Update existing SQL Server 2012 Reporting Services deployments to SQL Server 2012 SP1.

  • Upgrade existing SQL Server 2008 and SQL Server 2008 R2 Reporting Services deployments to SQL Server 2012 SP1.

  • Install new instances of SQL Server 2012 SP1 Reporting Services.

Rssharepoint.msi

Download and install the SQL Server 2012 SP1 version of the add-in for SharePoint products. Microsoft® SQL Server® 2012 SP1 Reporting Services Add-in for Microsoft® SharePoint® (https://www.microsoft.com/en-us/download/details.aspx?id=35583).

Arrow icon used with Back to Top link Top

Native mode report servers

The following table summarizes the SQL Server 2012 SP1 update and slipstream workflows related to Reporting Services in Native mode. It is recommended that all report servers in a Scale-out deployment are the same version of Reporting Services.

2012 SP1 installation package

Description

Update Package

Run the update package on an existing deployment of SQL Server 2012 Reporting Services report server in Native mode.

Slipstream package

Run the slipstream package to complete one of the following:

  • Update existing SQL Server 2012 Reporting Services deployments to SQL Server 2012 SP1.

  • Upgrade existing SQL Server 2008 and SQL Server 2008 R2 Reporting Services deployments to SQL Server 2012 SP1.

  • Install new instances of SQL Server 2012 SP1 Reporting Services.

Arrow icon used with Back to Top link Top

Report Builder

A new version of SQL Server 2012 Report Builder 3.0 released with SQL Server 2012 SP1. The new version of Report Builder includes fixes but it does not include new features.

Arrow icon used with Back to Top link Top

SQL Server SP1 Downloads

Microsoft® SQL Server® 2012 SP1 PowerPivot® for Microsoft® SharePoint® (https://www.microsoft.com/en-us/download/details.aspx?id=35577).

Microsoft® SQL Server® 2012 SP1 Reporting Services Add-in for Microsoft® SharePoint® (https://www.microsoft.com/en-us/download/details.aspx?id=35583).

Microsoft® SQL Server® 2012 Service Pack 1 (SP1) (https://www.microsoft.com/en-us/download/details.aspx?id=35575).

Microsoft® SQL Server® 2012 SP1 Report Builder (https://www.microsoft.com/en-us/download/details.aspx?id=35576).

Microsoft® SQL Server® 2012 SP1 Feature Pack (https://www.microsoft.com/en-us/download/details.aspx?id=35580).

Arrow icon used with Back to Top link Top

Installation Package User Interface Reference

This section shows what the primary user interface looks like when running the SQL Server 2012 SP1 installation packages.

Slipstream Package: The following image is one of the pages you see when you run the SQL Server 2012 SP1 slipstream installation package. Note in this image you see a list of the currently installed SQL Server 2008 components, as indicated by the version 10.51.2550. The SQL Server 2008 components upgrade to SQL Server 2012 SP1.

sql server 2012 sp1 slipstream upgrade UI

  

For more information on slipstream installations, see the SQL Server 2012 SP1 Full Installation section of Overview of SQL Server Servicing Installation https://technet.microsoft.com/en-us/library/dd638062.aspx).

Update Package: The following image is one of the pages you see when you run the SQL Server 2012 SP1 update installation package. You see a list of the currently installed SQL Server 2012 features and you can select the features you want to update.

sql server 2012 SP1 update user interface

  

Arrow icon used with Back to Top link Top

See Also

Concepts

Install or Uninstall the PowerPivot for SharePoint Add-in

Install Reporting Services SharePoint Mode for SharePoint 2013

Upgrade Workbooks and Scheduled Data Refresh (SQL Server 2012 SP1)

Migrate a Reporting Services Installation (SharePoint Mode)

Local Language Versions in SQL Server