Message Queue Server Installs Limited Version of SQL Server 6.5

ID: Q172307

The information in this article applies to:

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.

Additional reference words: prodsql enterprise SQL message queue

Version           : WinNT:1.0
Platform          : winnt
Issue type        : kbinfo

Last Reviewed: July 14, 1998