Microsoft Message Queue server comes with limited SQL 6.5

AUTHOR: mlucas PRODUCT: winnt TITLE: Microsoft Message Queue server comes with limited SQL 6.5 SECURITY: PUBLIC TECH REVIEWED: gregorh

The information in this article applies to:

- Microsoft Message Queue Server, version 1.0

• Microsoft SQL Server, version 6.5

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 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 MSMQ Administrator's Guide discussed issues surrounding this limitation.

MSMQ, by default, maintains a single connection to the database on the SQL server. For this reason, you need a single client license for each SQL Server installation that it uses. You may use the MSMQ Control Panel to increase the number of connections between MSMQ and the database. For each additional connection you need an additional client license. Each connection counts as one SQL Server connection, requiring onr SQL client license. You should use fewer connections than the maximum available client licenses. Otherwise, programs that require additional connections to the SQL Server may not be able to operate while MSMQ is running.