Microsoft KB Archive/214710

= BUG: MSMQ PEC, PSC, BSC Setup Fails with SQL Server 7.0 =

Article ID: 214710

Article Last Modified on 10/26/2007

-

APPLIES TO


 * Microsoft Message Queue Server 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:


 * Install the Windows NT Option Pack (without MSMQ selected).
 * Restart the computer.
 * 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:   From a command prompt issue the following: \mssql7\binn\scm -Action 7 -Service SQLServerAgent -Dependencies ""  Install MSMQ.  From a command prompt issue the following: \mssql7\binn\scm -Action 7 -Service SQLServerAgent -Dependencies MSSQLServer 

Keywords: kbproductlink kbbug kbfix KB214710

-

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

© Microsoft Corporation. All rights reserved.