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

Chapter 3: Install SQL Server Instances 12

We recommend that you install the Non-Instance-Aware components

only once per server. Any future install templates should not include

these components. After each installation, check the logs for information

such as whether a reboot is necessary.

The following Books On Line (BOL) article provides a summary of the

issues associated with installing multiple instances on a single node:

http://msdn2.microsoft.com/en-us/library/ms143531.aspx

The next article lists the default file locations for all components of a SQL

Server 2005 instance and explains concepts for the installed instances of

the Database Engine, Analysis Services, and Reporting Services. As you

review this article, note that moving the installed data file directories for

the configurable components has not been tested with MxDB for SQL

Server; however, as long as the configuration is identical for an instance

across all nodes, it should be functional.

http://msdn2.microsoft.com/en-us/library/ms143547.aspx

The following articles contain tables listing the directory structure and

configurable components:

http://msdn2.microsoft.com/en-us/library/ms143688.aspx

http://msdn2.microsoft.com/en-us/library/ms144275.aspx

The following article discusses installing components. Be sure to review

the footnotes for the table. Also note that installing both 32-bit and 64-bit

Reporting Services on a node running a 64-bit operating system is not

supported by Microsoft or MxDB for SQL Server.

http://msdn2.microsoft.com/en-us/library/ms143786.aspx

Set Permissions on Existing PSFS Filesystems

If you will be installing a SQL 2005 instance on a mountpoint for a PSFS

filesystem created under Matrix Server 3.2 or earlier, the installation may

fail if the file permissions are not set appropriately. You can use any of the

following methods to set the permissions if necessary.

• Mount the filesystem as a drive letter (for example, s:\). In Windows

Explorer, open the Properties for the volume and select the Security

tab. Then set the permissions to Full Control for Administrators/users.