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.

Posted: August 31, 2011 in BizTalk
Tags: , , ,

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

Tags: BizTalk | BAM | Configuration | Errors and Warnings, Causes and Solutions

Comments
  1. Saved me a ton of time. Thanks for posting!

  2. OldBeno says:

    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…

  3. Hans says:

    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)

  4. Anonymous says:

    Sandro you are a life saver.

  5. Thanks all for the comments!

  6. Venkatesh says:

    No need to install SSIS on biztalk server ????

  7. Aecio Lemos says:

    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.

  8. Aecio Lemos says:

    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

  9. Aecio Lemos says:

    Ops, I forgot to paste the link to the article. But you know it already, there is a comment by you at the end🙂

    http://social.technet.microsoft.com/wiki/contents/articles/1888.install-and-configure-bam-business-activity-monitoring-in-a-multi-computer-environment.aspx#Scenario

  10. Jaco Becker says:

    The same stil has to be done for BizTalk Server 2013 and BizTalk Server 2013 configuration

  11. Marcus Petersson says:

    Thank you! This saved me a lot of time!

  12. Vikram Rayasam says:

    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.

  13. Omar Lopez says:

    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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s