3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Chapter 3: Install SQL Server Instances 10

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.

• The Microsoft .NET Version 2.0 framework must be installed on all

nodes.

• If you will be installing SQL Server 2000 instances and SQL Server

2005 instances on the same node, the SQL Server 2000 instances

(including SP4) must be installed first.

• 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 instance called

“instance1” on the primary node, you will also need to install an

instance called “instance1” on the backup node.

Supported Number of SQL Instances

MxDB for SQL Server supports up to 16 SQL Server 2000 instances and 50

SQL Server 2005 instances per node.

If SQL Server 2000 and 2005 instances will be installed on the same node,

the SQL Server 2000 instances (including SP4) must be installed first.