3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 2: Install SQL Server 8

Install a SQL Server 2005 Instance

Installation Overview

This procedure uses the SQL Server silent installation feature to perform

an unattended installation of a SQL Server instance on multiple nodes of

the matrix.

Installation Considerations

When installing SQL Server instances, you should be aware of the

following:

• 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.

• The MxDB for SQL Server installer creates an INI template file that is

used for the unattended SQL Server installation. The password stored

within the INI file is 128-bit encrypted. To increase the security of your

servers, we recommend that you remove the INI files after

successfully installing SQL Server 2005.

Install a Service Pack. Copy Service Pack files to a PSFS filesystem and then

install the Service Pack. (Service Pack 4 requires that

Service Pack 3 first be installed.) See “Install a SQL

Server 2000 Service Pack” on page 32.



Install any hotfixes. Copy the hotfix to a PSFS filesystem and then install the

hotfix. See “Install a SQL Server Hotfix” on page 35.



Install any additional

SQL instances.

Record a new template file if desired and then install the

instance, the appropriate service packs, and any hotfixes.



Action Description