Article ID: 905730
Article Last Modified on 9/28/2005
APPLIES TO
- Microsoft BizTalk Accelerator for RosettaNet 3.0 Standard Edition
- Microsoft BizTalk Accelerator for RosettaNet 3.0 Enterprise Edition
SYMPTOMS
When you run the Microsoft BizTalk Accelerator for RosettaNet 3.0 Configuration Wizard to configure the BizTalk Accelerator for RosettaNet 3.0, you may receive an error message that is similar to the following:
You can complete the BizTalk Accelerator for RosettaNet 3.0 configuration. However, you receive Business Activity Monitoring (BAM) error messages in the Application event log when you use the BizTalk Accelerator for RosettaNet 3.0 adapter to send or to receive documents.
CAUSE
This issue occurs because one or more of the following conditions are true:
- The BizTalk databases are located on a computer that is running Microsoft SQL Server, and this computer is a remote computer. Additionally, the SQL Client Tools are not installed on the computer where Microsoft BizTalk Server 2004 is installed. This issue can also occur if the same service packs or hotfixes are not installed on the computer where SQL Server is installed and on the computer where BizTalk Server 2004 is installed.
- The user who runs the BizTalk Accelerator for RosettaNet 3.0 Configuration Wizard does not have permissions to create or to modify databases on the computer where SQL Server is installed. This issue can also occur if the user does not have permission to create Data Transformation Services (DTS) packages.
- A previous installation of the BizTalk Accelerator for RosettaNet 3.0 used the same computer that is running SQL Server.
Note This issue occurs when the BizTalk Accelerator for RosettaNet 3.0 Configuration Wizard tries to run the following command:
bm.exe deploy "c:\Program Files\Microsoft BizTalk Accelerator for RosettaNet 3.0\BAMTracking\Tracking.xml
RESOLUTION
You may be able to resolve this issue by using the following methods, in the order in which they are presented:
Method 1: Verify the computer configuration
To verify the computer configuration, confirm that the SQL Client Tools are installed on the computer where BizTalk Server 2004 is installed. You should also verify that the same service pack and hotfix packages are installed on both the computer where SQL Server is installed and the computer where BizTalk Server 2004 is installed.
For more information about how to determine what SQL Server version is running on a computer, click the following article number to view the article in the Microsoft Knowledge Base:
321185 How to identify your SQL Server service pack version and edition
Method 2: Verify permissions on the computer that is running SQL Server
Verify that the user who is running the BizTalk Accelerator for RosettaNet 3.0 Configuration Wizard has permissions to create and to modify databases and has permission to create DTS packages. To do this, follow these steps:
- Start SQL Server Enterprise Manager.
- Expand Microsoft SQL Servers, expand SQL Server Group, expand the SQL Server that you want, and then expand Security.
- In the left pane, click Logins.
- In the right pane, right-click the user who you want to configure, and then click Properties.
- On the Server Roles tab, verify that the Database Creators check box is selected, and then click OK.
For more information about how to manage permissions for DTS packages, click the following article number to view the article in the Microsoft Knowledge Base:
282463 Managing permissions for DTS packages in an Enterprise environment
Method 3: Delete the BAM_DM_Message and BAM_DM_Process DTS packages
To delete the BAM_DM_Message and BAM_DM_Process DTS packages, follow these steps:
- Start SQL Server Enterprise Manager.
- Expand Microsoft SQL Servers, expand SQL Server Group, expand the SQL Server that you want, and then expand Data Transformation Services.
- In the left pane, click Local Packages.
- In the right pane, right-click BAM_DM_Message, click Delete, and then click Yes.
- In the right pane, right-click BAM_DM_Process, click Delete, and then click Yes.
Method 4: Reapply the tracking information
To reapply the tracking information, follow these steps:
- Click Start, click Run, type cmd, and then click OK.
- At the command prompt, change to the folder where the Bm.exe file is located. By default, the Bm.exe file is located in the \Program Files\Microsoft BizTalk Server 2004\Tracking folder.
- At the command prompt, type the following command:
bm.exe deploy "c:\Program Files\Microsoft BizTalk Accelerator for RosettaNet 3.0\BAMTracking\Tracking.xml"
- Type exit to close the Command Prompt window.
Keywords: kbtshoot kbprb KB905730
