Either another TDDS is processing the same data or there is an orphaned session in SQL server holding TDDS lock. Either another TDDS is processing the same data or there is an orphaned session in SQL Server holding TDDS lock. SQL Server: \. Database: BizTalkDTADb
The above error seems to indicate that more than one TDDS is processing at the same time / on the same data, locking it and preventing access to it. If you experience this error in a clustered / multi-node BizTalk Server environment, follow these steps to ensure that your domain groups are added to the proper SQL Server database rolls that are created when BTS is installed. (NOTE: You will have to do this on each SQL Server instance where BizTalk is installed.)
- Execute SQL Server Enterprise Manager (EM).
- Expand the SQL Server instance we are working with, and expand Databases.
- Expand the BAMArchive database, and select Roles.
- Double-click (or right-clickàProperties) the BTS_ADMIN_USERS role. If the domain group BizTalk Server Administrators group is not a member of this role, click the Add button to add it. (NOTE: If the group does not appear as available when you click add, you will need to cancel this, select Logins for this database, and add the \BizTalk Server Administrators group as a new login to this database before you can add it as a role.)
- Click okay to save.
- Select Users on the left and ensure that the BizTalk Isolated Host Users group is a login for this database. If it is not, right-click on the right pane, select New User and add this login to this database.
- Select Roles on the left, and double click the BTS_HOST_USERS role. IF the \BizTalk Isolated Host Users group is not a member of this role, click Add and add this login to this role. Click OK when done.
- Expand the database BAMPrimaryImport on the left.
- Select Users and here we need to add our BizTalk Service Account. This is not done automatically during the ConfigFramework.
- Right-click on the right pane, select New User and add our service account login to this database.
- Next, click Roles and double click the BAM_EVENT_WRITER role on the right. Add our service (BtsService) account, and the BizTalk Server Administrators logins to this role.
- Click OK to save.
- Double click the BAMQueryWS role and add our service (BtsService) account and the BizTalk Isolated Host Users accounts to this role.
- Click OK to save.
- Next, expand the BizTalkDTADb database object, and select Roles on the left.
- On the right double-click the BAM_EVENT_WRITER role, and add the BizTalk Server Administrators login and the service (BtsService) login to this role. Click OK to save.
- Double-click the HM_EVENT_WRITER role, and add the BizTalk Server Administrators and the service account to this role as well. Click OK to save.
- Next, expand the BizTalkMgmtDb database object, and select Roles on the left.
- Double-click the BAM_CONFIG_READER role, and add the service account to this role. Click OK to save.
- Next, expand the BizTalkMsgBoxDb database object, and select Users.
- Right-click on the right pane, select New User and add the service account as a login to this database. Click OK to save. Now select Roles on the left.
- Double-click the BAM_EVENT_READER role, and add the service account to this role. Click OK to save.