4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

Prerequisites
SQL Server 2008 prerequisites
SQL Server 2008 requires that the following be installed:
• Windows Installer 4.5
• NET Framework 3.5 SP1
• SQL Server Native Client
• SQL Server Setup Support Files
• Powershell 1.0
In-place upgrade prerequisites
Before starting the upgrade, complete these steps:
• Back up all databases that will be upgraded.
• Prepare databases for the upgrade. Use Microsoft Upgrade Advisor or a similar
tool. The Upgrade Advisor analyzes the SQL Server 2005 instances and reports
issues that may affect the upgrade. It also provides tips for fixing or working
around the issues.
• Stop PolyServe Instance Aliasing (Open services.msc and stop the service).
• Start the SQL Browser. If you are using Instance Aliasing, see “Configure Instance
Aliasing settings” on page 123 for information about stopping the PolyServe SQL
Browser and starting the SQL Browser.
• Ensure that the VSQL/VSSAS is running on its primary node and not on any
backup node.
• Place the Virtual SQL/Virtual SSAS instances into maintenance mode. (Select the
Virtual SQL Server/Virtual SSAS on the PolyServe Management Console, right-
click, and select Maintain.)
Restrictions
Following are some of the Microsoft restrictions affecting the upgrade.
• A cross-platform, in-place upgrade from a 32-bit instance of SQL Server 2005
(x86) to a 64-bit instance of SQL Server 2008 (x64) is not supported.
• The in-place upgrade cannot be used if you want to upgrade only a single data-
base.
Upgrade SQL Server/SSAS 2005 instances in place46