Installing and Configuring Microsoft SQL Server

If the 60 MB limit of the limited version of SQL Server 6.5 is not sufficient for your enterprise, you must manually install and configure the retail release of SQL Server version 6.5. You must not install SQL Server version 6.5 Service Pack 2. It is not compatible with MSMQ. You can, however, use either SQL Server version 6.5 Service Pack 1 or SQL Server version 6.5 Service Pack 3.

Note Before you start Microsoft SQL Server Setup, you must log on to the computer under an account that has administrative privileges on the computer.

To avoid ODBC configuration issues, close all ODBC applications before installing SQL Server.

By default, each SQL database has only one client (the MSMQ service running locally on that computer). Because only the local MSMQ server on the PEC, PSC, or BSC accesses the SQL database directly, you need only one client license for each SQL Server installation. However, if you use the MS Message Queue Control Panel applet to increase the number of connections between the MSMQ server and the MSMQ information store (the SQL database), you need to acquire additional client licenses. Each connection counts as one SQL Server connection, requiring one SQL client license. However, the MQIS database uses all the connections assigned to it. Therefore, when you set the MQIS connection using the MS Message Queue icon in Control Panel, you should use less than the maximum available client licenses. Otherwise, programs that require additional connections to MQIS or other SQL databases will not be able to operate while MSMQ is running.


To install the retail release of Microsoft SQL Server version 6.5

  1. From the folder containing the software compatible with your hardware platform's processor architecture, run Setup.exe and complete each dialog box that appears.
  2. From the Options dialog box, select Install SQL Server and Utilities, and then click Continue.
  3. Follow the on-screen instructions. From the Installation Options dialog box, select Auto Start SQL Server at boot time. From the SQL Executive Log On Account dialog box, select Install to log on as Local System account.

For help on other dialog box options, click the Help button or press F1 to access the setup program's online Help. For more information about each option presented during installation, see your SQL Server documentation.

After you have installed SQL Server version 6.5, you must configure it for use with MSMQ


To configure the retail release of SQL Server version 6.5 for use with MSMQ

  1. Click Start, point to Programs, point to Microsoft SQL Server 6.5, and click SQL Setup.
  2. Click Continue, and then click Continue again.
  3. Click Set Security Options and then click Continue.
  4. Click Windows NT Integrated and then click OK.
  5. Click the Exit to Windows NT button.
  6. Click Start, point to Programs, point to Microsoft SQL Server 6.5, and click SQL Service Manager.
    7. 7. If the database is stopped, double-click Start/Continue. if the database is running, double-click Stop. When the database has stopped, double-click Start/Continue.

© 1997 by Microsoft Corporation. All rights reserved.