Microsoft KB Archive/888753

= BUG: The tracking table is not updated, and you do not receive an error message to indicate that the tracking table has not been updated in BizTalk Server 2004 =

Article ID: 888753

Article Last Modified on 3/4/2005

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Standard Edition

-





SYMPTOMS
In Microsoft BizTalk Server 2004, the Host Tracking option is updated after you change the Host Tracking check box for the BizTalkDTADb tracking database. However, the BizTalk tracking table is not updated, and you do not receive an error message to indicate that the tracking table has not been updated. This problem occurs when you click to select or you click to clear the Host Tracking check box

Therefore, you may not notice that the tracking table is no longer synchronized.



CAUSE
This problem occurs if you do not have the db_securityadmin role for the BizTalkDTADb database.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.



WORKAROUND
To work around this problem, grant the db_securityadmin role to the user for the BizTalkDTADb database. To do this, follow these steps:
 * 1) Click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
 * 2) In SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, and then expand  .

In this step, replace  with the name of the computer that is running the instance of Microsoft SQL Server 2000 where the BizTalkDTADb database is located.
 * 1) Expand Security, and then click Logins.
 * 2) Right-click the user who you want to give the db_securityadmin server role to, and then click Properties.
 * 3) In the SQL Server Login Properties dialog box, click the Database Access tab. Then, click to select the Permit check box that corresponds to the BizTalkDTADb database.
 * 4) In the Database roles for ‘BizTalkDTADb’ list, click to select the db_securityadmin check box, and then click OK.

Additional query words: BTS Ebiz

Keywords: kbtshoot kbbug kbpending KB888753

-

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

© Microsoft Corporation. All rights reserved.