Geeks With Blogs
Andy Morrison's BizTalk Blog Help, I've fallen and I can't BizTalk!

Recently I had to configure a BizTalk 2006 multi-server environment that someone else had built out (installed BizTalk, SQL, prerequisites, etc.)  When running the BizTalk configuration tool I would get the following error:

 

"BizTalk 2006 Configuration: Microsoft SQL Server 2005 Data Transformation Services (DTS) for BAM Archiving is not installed on the local machine.  Please install Microsoft SQL Server 2005 Integration Services.  (Microsoft.BizTalk.Bam.CfgExtHelper.ToolsHelper" ... Additional information: “Could not load file or assembly ‘Microsoft.SqlServer.ManagedDTS, Version=9.0.242.0”…

 

I assumed that the SQL Client Tools weren’t installed, which is a requirement per the installation guides.  I also found this post on the same problem, http://blogs.msdn.com/mattlind/archive/2006/08/30/730575.aspx

 

This hunch (which the post confirmed) turned out to be correct so I tracked down the SQL Server DVDs; however, when installing the required SQL Client Tools I would get this error message when the setup package was trying to install OWC11:

 

"Error 1706.  Setup cannot find the required files.  Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:\Program Files\Microsoft Office\OFFICE11\1033\SETUP.CHM"

  

Since it was failing on the OWC11 portion of the installation I had a hunch that it was the already installed OWC11 (11.0.8003.0) (likely from the BizTalk 2006 pre-requisites .cab file) that was causing the SQL Client Tools setup program problems so I uninstalled OWC11 and then tried to install the SQL Client Tools again.  They installed successfully this time (and they installed OWC11 (11.0.6558.0).

 

I decided to repair BizTalk since things we’re being installed in an odd order; additionally, I extracted the owc11.exe (installer) from the BizTalk prerequisites cab and installed it to be safe.  Now the OWC11 version is back to (11.0.8003.0)

 

I ran the BizTalk configuration tool again it worked smoothly.

 

So, please follow the installation guides carefully to avoid having to troubleshoot your installation/configuration - or at least to avoid increasing the chances of having to troubleshoot J.

Posted on Monday, November 27, 2006 2:44 PM BizTalk | Back to top

Copyright © Andy Morrison | Powered by: GeeksWithBlogs.net