Unable to configure BAM Tools
While installing BizTalk 2010 in a multi-server configuration (one server for BizTalk, a different server for SQL), I received the following error while attempting to configure the 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. Could not load file or assembly
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 wording of the suggested solution takes a too literal approach. Whilst installing Integration Services would solve the problem, only the actual DLL library ‘Microsoft.SqlServer.ManagedDTS‘ needs to be installed.
This can be done by performing an install from the Sql Server installation media, but choosing to install only the following:
- – Management Tools – Basic
- – Management Tools – Complete
It should now be possible to complete the configuration successfully.
-
Archives
- April 2015 (1)
- July 2013 (1)
- May 2013 (2)
- March 2013 (1)
- February 2013 (1)
- January 2013 (1)
- December 2012 (1)
- November 2012 (1)
- October 2012 (1)
- September 2012 (2)
- July 2012 (2)
- June 2012 (1)
-
Categories
-
RSS
Entries RSS
Comments RSS