Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172307

From BetaArchive Wiki
Knowledge Base

Message Queue Server Installs Limited Version of SQL Server 6.5

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