4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

Contents
1 Introduction ....................................................................................... 9
Virtual SQL Servers ..................................................................................................................... 9
Active-Passive architecture ...................................................................................................... 9
Plan Your SQL configuration ................................................................................................ 10
Active-Active ............................................................................................................... 10
Many-to-One .............................................................................................................. 10
SQL monitors and failover ................................................................................................... 11
What happens during a failover? ......................................................................................... 11
Replication of registry keys .................................................................................................. 12
Virtual MSDTC .......................................................................................................................... 12
Virtual SSAS ............................................................................................................................. 12
2 Install SQL Server instances ............................................................... 13
SQL Server installation overview ................................................................................................. 13
SQL Server and operating system support .............................................................................. 13
General prerequisites .......................................................................................................... 13
Supported number of SQL instances ..................................................................................... 13
Installation considerations for SQL Server 2008 ..................................................................... 14
Installation prerequisites ................................................................................................ 14
Using Mixed Mode authentication ................................................................................. 14
Template file ............................................................................................................... 14
IP network configuration ............................................................................................... 14
Virtual MSDTC ............................................................................................................. 14
“Instance-Aware” and “Non-Instance-Aware” components ................................................. 15
Instance ID .................................................................................................................. 15
File streaming implications ............................................................................................ 15
Account provisioning .................................................................................................... 16
Set permissions on existing PSFS filesystems ..................................................................... 16
SQL Server 2008 references ................................................................................................ 16
Installation considerations for SSAS 2008 instances ................................................................ 17
Installation considerations for SQL Server 2005 ..................................................................... 17
Template file ............................................................................................................... 17
IP network configuration ............................................................................................... 17
SQL Server 2005 SP2 required for Full Text Search .......................................................... 17
Virtual MSDTC ............................................................................................................. 17
“Instance-Aware” and “Non-Instance-Aware” components ................................................. 17
Set permissions on existing PSFS filesystems ..................................................................... 18
Installation considerations for SSAS 2005 instances ................................................................ 19
Run the Multi-Node Install Wizard for SQL Server ......................................................................... 19
Install SQL Server 2008 instances ........................................................................................ 19
Install SQL Server 2005 instances ........................................................................................ 27
Other installation tasks .............................................................................................................. 33
Adjust the Maximum Memory setting for SQL Server ............................................................... 33
Requirement for BUILTIN\Administrators group ....................................................................... 34
TCP/IP Assignments on backup nodes ................................................................................... 34
HP PolyServe Software for Microsoft SQL Server administration guide 3