BTS 2020 - stuck on BAM configuration step

Salam ELIAS 302 Reputation points
2025-07-23T20:17:38.8666667+00:00

Hi, I followed all instructions at https://learn.microsoft.com/en-us/biztalk/install-and-config-guides/hardware-and-software-requirements-for-biztalk-server-2020, when configure operation started, I got stuck at the BAM configuration with the error :

TITLE: Microsoft BizTalk Server Configuration Wizard


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. (15)

For help, click: http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft+BizTalk+Server&ProdVer=3.13.717.0&EvtSrc=15&EvtID=error_DTS2016Archive


ADDITIONAL INFORMATION:

Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.BizTalk.Bam.CfgExtHelper)

For help, click: http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft+BizTalk+Server&ProdVer=3.13.717.0&EvtSrc=Microsoft.BizTalk.Bam.CfgExtHelper&EvtID

My SQL is a remote 2K19 . Here is a snpashot of the error

User's image

Thanks for your help

BizTalk Server
BizTalk Server

A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.