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

Contents
1 Introduction ...................................................................... 9
Virtual SQL Servers .............................................................................................. 9
Active-Passive architecture .............................................................................. 9
Plan Your SQL configuration ......................................................................... 10
Active-Active ........................................................................................ 11
Many-to-One ....................................................................................... 11
SQL monitors and failover ............................................................................ 12
What happens during a failover? ................................................................. 13
Replication of registry keys ........................................................................... 13
Virtual SSAS ..................................................................................................... 13
2 Install SQL Server instances .............................................. 15
SQL Server installation overview .......................................................................... 15
SQL Server and operating system support ...................................................... 15
General prerequisites .................................................................................. 15
Supported number of SQL instances .............................................................. 16
Installation considerations for SQL Server 2008 .............................................. 16
Installation prerequisites ........................................................................ 16
Using Mixed Mode authentication .......................................................... 17
Template file ........................................................................................ 17
IP network configuration ........................................................................ 17
Instance-Aware and Non-Instance-Aware components ......................... 17
Instance ID .......................................................................................... 18
File streaming implications ..................................................................... 19
Account provisioning ............................................................................ 19
SQL instance cannot be virtualized if the directories of the SQL Instance are
not in the same path ............................................................................. 19
Set permissions on existing PSFS filesystems ............................................. 19
SQL Server 2008 references ......................................................................... 20
Installation considerations for SSAS 2008 instances ........................................ 21
Installation considerations for SQL Server 2005 .............................................. 21
Template file ........................................................................................ 21
IP network configuration ........................................................................ 21
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 3