BUG: MSMQ PEC, PSC, BSC Setup Fails with SQL Server 7.0 (214710)


The information in this article applies to:

  • Microsoft Message Queue Server (MSMQ) 1.0
This article was previously published under Q214710

SYMPTOMS

When using the Windows NT Server version 4.0 Enterprise Edition, Microsoft Message Queue Server (MSMQ) Setup of a Primary Enterprise Controller (PEC), Primary Site Controller (PSC), or Backup Site Controller (BSC) fails to install with Microsoft SQL Server version 7.0. A message appears saying the Message Queue Server cannot stop the SQL Server service.

CAUSE

SQL Server 7.0 creates the SQLAgent Service with a dependency on SQL Server. This causes Message Queue Server Setup to fail when it attempts to stop SQL Server because a dependent service is running.

RESOLUTION

Use either of these procedures to resolve the problem:
  • In order to install Message Queue Server from the Windows NT Server 4.0 Enterprise Edition, you must remove the SQLServerAgent dependency on SQL Server. Do this by using the Service Control Manager tools in the Sql\Binn directory. See MORE INFORMATION, below, for details.
  • Alternatively, you can use Windows NT Option Pack to install Message Queue Server. This problem does not happen if you install from the Option Pack. To perform this procedure:

    1. Install the Windows NT Option Pack (without MSMQ selected).
    2. Restart the computer.
    3. Rerun Option Pack Setup and add Message Queue Server using the Option Pack Setup Add/Remove Wizard.
Regardless of which option you use, reinstall Windows NT Server 4.0 Service Pack 4 (or later) after installing Message Queue Server.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Installation requires removal of the SQLAgent dependency on SQL Server, installation of Message Queue Server, and then re-establishment of the dependency:
  1. From a command prompt issue the following: 
    \mssql7\binn\scm -Action 7 -Service SQLServerAgent -Dependencies ""
  2. Install MSMQ.
  3. From a command prompt issue the following: 
    \mssql7\binn\scm -Action 7 -Service SQLServerAgent -Dependencies MSSQLServer
Modification Type:MajorLast Reviewed:9/30/1999
Keywords:kbbug KB214710
©2002 Microsoft Corporation. All rights reserved.