BizTalk 2010 – BAM Tools configuration error: Microsoft SQL Server Data Transformation Services (DTS) 2008 with SP1 or higher for BAM Archiving is not installed on the local machine.

When trying to configure BAM features in BizTalk Server 2010 (64 bit) with a remote SQL Server 2008 R2 (64 bit) I was getting these two errors:

When trying to configure “BAM Archive Database”

Microsoft SQL Server Data Transformation Services (DTS) 2008 with SP1 or higher for BAM Archiving is not installed on the local machine. Please install Microsoft SQL Server 2008 Integration Services. (Microsoft.BizTalk.BAM.CfgExtHelper.ToolsHelper)

BAM Archive Database error

And when trying to configure “BAM Analysis Database”

Microsoft SQL Server Data Transformation Services (DTS) 2008 with SP1 or higher for BAM Archiving is not installed on the local machine. Please install Microsoft SQL Server Integration Services 2008 with SP1 or higher. (Microsoft.BizTalk.BAM.CfgExtHelper.ToolsHelper)

BAM Analysis Database error

Both errors with the same additional information:

——————————
ADDITIONAL INFORMATION:
Could not load file or assembly ‘Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified. (Microsoft.BizTalk.Bam.CfgExtHelper)

Cause

As Kent Weare said in his post: “This error makes it sound like you need to install SQL Server Integration Services (SSIS) which is a little misleading.”

The documentation on MSDN indicates the following:

What 64-bit SQL Server components are required to configure BAM tools?

The configuration wizard is a 32-bit process; therefore it requires certain components which allow it to communicate with 64-bit SQL Server. You must install the following SQL Server client components to enable configuration of BAM tools:

  • Connectivity Components
  • Management Tools
  • Legacy Components

Solution

  • Install the SQL Server 2008 R2 Management Tools (Basic & Complete) features as shown in the screenshot onto the BizTalk Server 2010:
SQL Server 2008 R2 Management Tools
Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

16 thoughts on “BizTalk 2010 – BAM Tools configuration error: Microsoft SQL Server Data Transformation Services (DTS) 2008 with SP1 or higher for BAM Archiving is not installed on the local machine.”

  1. Sandro,

    Just to say thanks for all the great information you have posted about Biztalk installation. You have helped me through a number of issues already and i’m positive i’ll be back onto your blog for more information..

    keep up the good work 🙂
    OldBeno…

  2. Thanks for this!
    I didn’t read this before I installed SSIS on my Biztalk servers though 🙂

    But now I am up and running (withous SSIS)

  3. Hi, is it possible to configure BAM pointing to a separate database machine? Let me elaborate. Due to client restrictions, the datacenter will not install the reporting, notification and analysis services on the SQL Cluster. Only the database engine resides in the cluster. So I wonder if I can install these on a separate server and use it in BizTalk. Something like this:

    [BizTalk Server]——[Database Server]
    |——-[Reporting Server]—–|

    The BizTalk 2010 and the Reporting Server use the Database Server and BizTalk uses the Reporting Server for BAM.

    Is this possible? Thank you for any help.

  4. Hi Sandro, thank you for your reply. In this article, it shows exactly how to install BAM in a multi-computer environment, but even in this scenario, you need to install SSIS and SSAS in the SQL server. What I thought of doing is installing a separate database in the BAM server (3-server configuration as in that article) and install SSIS and SSAS on that BAM server, but I don’t know if that would work, having two separate databases, one for the messagebox and other BizTalk tables and one for BAM tables in the BAM server. Have you ever seen this before?

    My problem is that the datacenter does not allow installing SSIS and SSAS on the SQL Cluster.

    Thanks

  5. Hello, Sandro Pereira, I follow your blogs for any help I require and I always get answers from them. You may not know but you made life easy for many people. I have a situation here. I am configuring Biztalk 2006 R2 and I am getting the same error. Our Admin confirmed that the components mentioned in the article are already installed in the server where SQL is installed. Just to Clarify, BizTalk is installed in Server A, and SQL installed in Server B. BizTalk is configured with Databases in Server B. All configurations were successful except for BAM tools. I am getting the same error. Should these
    Connectivity Components
    Management Tools
    Legacy Components
    be installed in Server A also where BizTalk is installed? Please help me with this.

  6. Hi Sandro.
    I’m dealing with this problem.
    I’ve already followed your post for installing Biztalk 2010 and when configuring Biztalk on Step8
    (https://sandroaspbiztalkblog.wordpress.com/2010/10/24/biztalk-2010-installation-and-configuration-installing-and-configuring-biztalk-server-part-8/)
    Receive an error message when trying to configure BAM Alerts

    Error: 2016-10-07 13:56:09:0516 [Error] BAMTools The version of Microsoft SQL Server Analysis Services on server LSABZTK01 must be the equivalent version as on the SQL server of the BAM Primary Import Database. (Microsoft.BizTalk.Bam.CfgExtHelper.ToolsHelper)

    How can I solve this problem?
    Was seeking a lot of forums and looked for many troubleshootings websites.
    All seems to be just fine, however error messasegs persist when trying to configure this feature.

    Regards.-

Leave a Reply

Your email address will not be published. Required fields are marked *

turbo360

Back to Top