Monday 9 April 2018

[BizTalk] Error while configuring BAM for BizTalk 2016

Problem:
While configuring BAM for BizTalk 2016, you may encounter the following error message:

"Microsoft SQL Server Data Transformation Services (DTS) 2016 or higher for BAM Archiving is not installed on the local machine. Please install Microsoft SQL Server 2016 Integration Services. (Sql2016)"




Cause:
This error is displayed because the BizTalk configuration tool did not find the version 13.0 of "Microsoft.SqlServer.ManagedDTS.dll" in the GAC.

Solution:
You can solve the issue by installing the DLL on the BizTalk Server using one the following means:
1. Install the SQL Server Client SDK using the SQL Server 2016 ISO image
2. Install SSDT tools
3. Install an older version (16.X) of the SQL Management Studio on the BizTalk Server



No comments: