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

SQL Server 2005 SP2 required for Full Text Search ................................... 21
“Instance-Aware” and “Non-Instance-Aware” components ......................... 21
SQL instance cannot be virtualized if the directories of the SQL Instance are
not in the same path ............................................................................. 23
Set permissions on existing PSFS filesystems ............................................. 23
Installation considerations for SSAS 2005 instances ........................................ 24
Run the Multi-Node Install Wizard for SQL Server .................................................. 24
Install SQL Server 2008 instances ................................................................. 24
Install SQL Server 2005 instances ................................................................. 34
Other installation tasks ....................................................................................... 41
Adjust the Maximum Memory setting for SQL Server ........................................ 41
Requirement for BUILTIN\Administrators group ................................................ 42
TCP/IP Assignments on backup nodes ........................................................... 42
3 Upgrade SQL Server/SSAS 2005 instances in place ........... 45
Prepare for the upgrade ..................................................................................... 45
Supported upgrades ................................................................................... 45
Prerequisites ............................................................................................... 46
SQL Server 2008 prerequisites ............................................................... 46
In-place upgrade prerequisites ............................................................... 46
Restrictions ................................................................................................. 46
Run the Multi-Node In-Place Upgrade Wizard ....................................................... 47
Start the In-Place Upgrade Wizard ................................................................ 47
“Select the Microsoft product to upgrade” dialog ............................................ 48
“Installation Credentials” dialog .................................................................... 50
“Select the Instances to Upgrade” dialog ....................................................... 51
“Select Template File” dialog ........................................................................ 52
Move Virtual SQL Servers/Virtual SSAS to operate mode ................................. 57
Add, edit, or delete products .............................................................................. 58
4 Update SQL Server instances ............................................ 61
Update overview ............................................................................................... 61
Location of service packs and hotfixes ........................................................... 61
Maintenance mode is required for update operations ...................................... 62
Update considerations for SQL Server 2008 ................................................... 62
Extract zip files .................................................................................... 62
Service pack and hotfix names ............................................................... 62
Use of a hidden administrative share ...................................................... 62
Update considerations for SQL Server 2005 ................................................... 63
Instance-Aware components ................................................................... 63
Extract zip files .................................................................................... 63
SQL Server 2005 SP2 required for Full Text Search ................................... 63
4