3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 2: Install SQL Server 20

on a PSFS volume where the hidden administrative share is not

yet created by LAN Manager, the setup will fail. To work around

this problem, use the following command to create an

administrative share on the PSFS volume. In the command, s:\ is

the PSFS volume.

net share s$=s:\ /grant:builtin\administrators,full

Install a SQL Server 2000 Instance

Installation Overview

This procedure uses the SQL Server silent installation feature to install

SQL Server 2000 on multiple nodes in the matrix.

Installation Considerations

When installing 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 uses an ISS template file to invoke

the SQL Server installation. The password stored within the ISS file is

encrypted by the Microsoft SQL Server 2000 installer utility and is

unknown to PolyServe. To increase the security of your servers, we

recommend that you remove the ISS files after successfully installing

SQL Server 2000.