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

2 Install SQL Server instances
This chapter describes how to install SQL Server 2005 and 2008 instances. You can also install SSAS
2005 and 2008 instances.
SQL Server installation overview
Before starting the installation, you should be aware of the following.
SQL Server and operating system support
HP PolyServe Software can be used with SQL Server 2005/2008 Standard and Enterprise Editions
(32-bit and 64-bit). Windows 2008 SP2, 64-bit, is the supported operating system.
General prerequisites
Before installing SQL Server, the following prerequisites should be met:
• PolyServe Matrix Server must be installed on each node. You will also need to create PSFS cluster
filesystems to store the SQL databases. The filesystems must use the 8 KB block size. If you will be
using a PSFS filesystem created under Matrix Server 3.2 or earlier, you will need to enable sparse
files on the filesystem. Use the following command to do this. (In the command, <device> can
be a drive letter, a mount point, or a psd or psv name.)
psfscheck --enable-sparse <device>
• Microsoft Cluster Services (MSCS) must not be installed.
• For SQL Server 2005, the Microsoft .NET Version 2.0 framework must be installed on all nodes.
For SQL Server 2008, .NET framework 3.5 must be installed.
• If you will be installing SQL Server Reporting Services, be sure to install the ISS and ASP.NET
components first, as described in Microsoft Knowledge Base article 934164:
http://support.microsoft.com/kb/934164
• SQL Server and the SQL Agent can be configured to use either the Local System account or a
Domain account. However, certain SQL Server features are not available if you use the Local
System account. Consult the Microsoft documentation for more information about these accounts
and the features they support.
• Multiple instances per node are supported.
• A primary SQL instance and its backup SQL instances must have the same name. For example, if
you install a SQL 2008 instance called “instance1” on the primary node, you will also need to
install a SQL 2008 instance called “instance1” on the backup node.
Supported number of SQL instances
HP PolyServe Software supports up to 50 SQL Server 2005/2008 instances per node.
HP PolyServe Software for Microsoft SQL Server administration guide 13