Consider the following information before upgrading to Analysis Center 2.9:
If you are upgrading both SQL Server and Analysis Center, upgrade Analysis Center first and then the SQL Server.
If the Analysis Center environment is distributed and runs more than one version of SQL Server, you need to install SQL Server Client Tools on the Data Warehouse computer. The Client Tools version must match the SQL Server version of the Data Mart computer.
If SQL Server 2005 is installed on the Data Mart computer, install the following four SQL Server 2005 Client Tools on the Data Warehouse computer: Connectivity Components, Software Development Kit, Legacy Components, and Management Tools. They are located under Client Components in the SQL Server 2005 setup program.
If SQL Server 2008 is installed on the Data Mart computer, install the following three SQL Server 2008 Client Tools on the Data Warehouse computer: Client Tools Connectivity, Client Tools SDK, and SQL Client Connectivity SDK. They are located under Shared Features in the SQL Server 2008 setup program.
If SQL Server 2012 is installed on the Data Mart computer, install the following three SQL Server 2012 Client Tools on the Data Warehouse computer: Client Tools Connectivity, Client Tools SDK, and SQL Client Connectivity SDK. They are located under Shared Features in the SQL Server 2012 setup program.
NOTE:Perform the following steps to upgrade Data Warehouse on the SQL cluster environment:
Upgrade Data Warehouse on the active node.
Perform a failover.
Upgrade Data Warehouse on the second node, which is now the active node.