Microsoft KB Archive/300266

= BUG: Lost Messages Occur When SQL Server Shuts Down Gracefully =

Article ID: 300266

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft BizTalk Server 2000 Standard Edition

-



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.

Keywords: kbbug kbpending KB300266

-

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

© Microsoft Corporation. All rights reserved.