Message Queue Server Installs Limited Version of SQL Server 6.5 (172307)
The information in this article applies to:
- Microsoft Message Queue Server (MSMQ) 1.0
- Microsoft SQL Server 6.5
This article was previously published under Q172307 SUMMARY
Microsoft Message Queue Server (MSMQ) is a fast store-and-forward service
for Microsoft Windows NT Server, Enterprise Edition (NTS/E) that requires
Microsoft SQL Server version 6.5 to store the Message Queue Information
Store (MQIS).
MORE INFORMATION
MSMQ requires Microsoft SQL Server 6.5 to store data. If you do not install
Microsoft SQL 6.5 prior to installing MSMQ, the MSMQ Setup program will
install a limited version of Microsoft SQL 6.5. This version is limited to
a cumulative total of 100 MB in database files. The "Choosing Between the
Full and Limited versions of SQL Server" section in the "Microsoft Message
Queue Server Administrator's Guide" discusses issues surrounding this
limitation.
MSMQ, by default, maintains a single connection to the database on the SQL
Server computer. For this reason, you need a single client license for each
SQL Server installation that it uses. You can use MSMQ Control Panel to
increase the number of connections between MSMQ and the database, however,
each additional connection requires another client license. Each connection
counts as one SQL Server connection, and requires one SQL client license.
You should use fewer connections than the maximum number of available
client licenses, otherwise, programs that require additional connections to
SQL Server may not be able to operate while MSMQ is running.
Modification Type: | Major | Last Reviewed: | 11/4/2003 |
---|
Keywords: | kbinfo KB172307 |
---|
|