BAM Configuration error BizTalk 2020

04.03.2021

Hi during the configuration's BizTalk 2020 appeare next error message: Microsoft SQL Server Integration Services (SSIS) is not installed on the local machine. The version of SSIS must be the equivalent version as on the SQL server of the BAM Archive Database. (14) Microsoft.SqlServer.ManagedDTS, version= 13.0.0.0.

Solution:

i have solved with next step:

  • install Microsoft SQL Server 2016 Integration Services on BT machine

  • create the SSISDB catalog on SQL Server machine

  • in BizTalk 2020 configuration point to SQL Server 2017 Machine

Now working.

Beste regards