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

ID: Q214710

The information in this article applies to:

Microsoft Message Queue Server version 1.0

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.
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 after installing Message Queue Server.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products 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

Additional query words:


Keywords          : kbMSMQ100 kbSQLServ700 
Version           : winnt:1.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: June 20, 1999