BUG: Lost Messages Occur When SQL Server Shuts Down Gracefully (300266)


The information in this article applies to:

  • Microsoft BizTalk Server 2000
This article was previously published under Q300266

SYMPTOMS

You may experience lost messages in your BizTalk Server application when Microsoft SQL Server shuts down gracefully.

CAUSE

The account that your BizTalk Server is using to access the SQL Server InterchangeSQ (Shared Queue) database does not have System Administrator Server Role privileges in SQL Server.

RESOLUTION

To resolve this problem, obtain the hotfix that is described in the following Microsoft Knowledge Base article:

301642 FIX: SQL Server Error Message 6002 Is Returned with an Incorrect Severity

WORKAROUND

To work around this problem, you need to change the account, which your BizTalk Server is using to connect to the Shared Queue database, to an account that has System Administrator privileges on the computer running SQL Server. It does not need to be the 'sa' account, but it must have System Administrator Server Role privileges on the computer running SQL Server. To change the Shared Queue database connection's user name and password, do the following:
  1. Start the BizTalk Server Administration Microsoft Management Console (MMC) interface. To do this, click Start, click Programs, click Microsoft BizTalk Server 2000, and then click BizTalk Server Administration.
  2. Click to expand the Microsoft BizTalk Server 2000 snap-in, right-click BizTalk Server Group, and then click Properties.
  3. Click the Connection tab in the BizTalk Server Group Properties dialog box.
  4. Enter a User name and Password for an account that has System Administrator privileges on the computer running SQL Server that contains the Shared Queue database, and then click OK.

STATUS

Microsoft has confirmed that this is a problem in BizTalk Server 2000.

MORE INFORMATION

These symptoms occur if you shut down SQL Server by using the Service Control Manager, or if the SQL Server computers are clustered and a fail-over is executed. In this scenario, SQL Server sends an informational message (6002 - SHUTDOWN is in progress. Log off.) to any connection that is being used by a non-system administrator account.

The 6002 message is strictly informational. Therefore, BizTalk Server continues processing messages until the connection to SQL Server is ended. If BizTalk Server is using a system administrator account, the 6002 message is not received from SQL Server, and BizTalk Server processes the timeout condition properly.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbbug kbpending KB300266
©2003 Microsoft Corporation. All rights reserved.