Microsoft KB Archive/172307
Article ID: 172307
Article Last Modified on 11/4/2003
- Microsoft Message Queue Server 1.0
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q172307
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).
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 query words: prodsql enterprise SQL message queue
Keywords: kbinfo KB172307