Microsoft KB Archive/172307

= Message Queue Server Installs Limited Version of SQL Server 6.5 =

Article ID: 172307

Article Last Modified on 11/4/2003

-

APPLIES TO


 * Microsoft Message Queue Server 1.0
 * Microsoft SQL Server 6.5 Standard Edition

-



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.

Additional query words: prodsql enterprise SQL message queue

Keywords: kbinfo KB172307

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.