4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 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). The supported operating systems are Windows
Server 2008 R2 Standard or Enterprise Edition (64-bit) and Windows Server 2008
R2 Standard or Enterprise Edition (64-bit) with Service Pack 1.
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:
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 15