MSMQ controller servers (the PEC, PSCs, and BSCs) use a SQL Server version 6.5 database to store the MQIS. You can purchase SQL Server 6.5 for each MSMQ controller server, or you can install a limited version of SQL Server 6.5 when you install each controller server.
The MSMQ limited version of SQL Server version 6.5 is limited to a cumulative total of 100 MB in database files. The SQL master database is 30 MB, which leaves 70 MB for a maximum MQIS database of 60 MB (with 10 MB left for the logging of MSMQ database updates). To determine if the number of queue and computer objects you can store in a 60 MB MQIS database is sufficient for your enterprise, see "Choosing Between the Full and Limited versions of SQL Server" in Chapter 6, "Deploying MSMQ." If your enterprise outgrows the limited version of SQL Server 6.5, you can purchase SQL Server version 6.5, upgrade the SQL installation on each MSMQ controller server, and increase the size of the MQIS database.
When you install an MSMQ controller server from the Windows NT Server, Enterprise Edition 4.0 Components CD, MSMQ Setup determines if an existing installation of SQL Server version 6.5 is available. If it is, MSMQ Setup uses that SQL Server installation. If SQL Server is not installed, MSMQ Setup installs the limited version of SQL Server version 6.5.
Note You cannot install the limited version of SQL Server 6.5 when you install an MSMQ controller server from an MSMQ installation share.
If you use an existing SQL Server installation, it must be configured properly for use with MSMQ. For more information on installing and configuring the retail version of SQL Server version 6.5, see the following section.
|
The MSMQ controller server's computer name must be a valid SQL identifier so SQL installs properly. The first character of the computer name must be a letter or an underscore. Characters following the first character can include letters, numbers, or the symbols -, #, $, or _. No embedded spaces are allowed. Contrary to the SQL documentation, computer names with hyphens are supported in SQL Server version 6.5. However, if you intend to use SQL Server with other applications, further configuration steps are required. For more information, see the MSMQ release notes (\MSMQ\readme.doc on your Windows NT Server, Enterprise Edition CD). If your computer name contains a hyphen, SQL Server Setup displays a warning message stating that the computer name is not valid. Click Resume to continue installing SQL Server. If characters that SQL does not recognize are used in the computer name, rename the computer before installing MSMQ or SQL Server. For instructions on renaming computers, see Windows NT online Help. Also, if the renamed computer is a member of a Windows NT Server domain, contact your network administrator to have the new computer name added to the domain. |