BAM Configuration error BizTalk 2020

Enrico 6 Reputation points
2021-02-24T09:36:36.77+00:00

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 How can I solve it? Thanks in advance

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
347 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Enrico 6 Reputation points
    2021-03-04T14:03:10.513+00:00

    Hi
    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

    1 person found this answer helpful.
    0 comments
  2. Kamlesh Kumar 3,861 Reputation points
    2021-02-24T13:40:49.843+00:00

    Dear member,

    Thank you for posting your question on the Microsoft Q&A platform.

    This error is coming because you don't have SSIS not installed and you need to install Microsoft SQL Server 2016 Integration Services. This is bundled with SQL Server, but needs to be installed. SSIS is a useful integration tool that allows you to perform ETL tasks.

    Kindly refer below MS doc link and screen-shot.
    https://learn.microsoft.com/en-us/biztalk/install-and-config-guides/configure-biztalk-server#custom-configuration

    71540-image.png

    Regards,
    Kamlesh Kumar

    0 comments
  3. Enrico 6 Reputation points
    2021-03-03T09:36:15.65+00:00

    Hi KamleshKumar
    thank you for your answer. Where is necessary to install? I want BT and SQL in a separate machine then it is necessary to install on SQL Server machine?

    Thanks in advance for your help

    best regards

  4. Enrico 6 Reputation points
    2021-03-04T10:39:02.187+00:00

    Hi
    i have installed Microsoft SQL Server 2016 Integration Services on SQL Machine but the error persist. In SQL machine was installed the version Microsoft SQL Server 2017 (Database engine and integration Services). I must unistall all Microsoft SQL Server 2017? Both database engine and integration services?

    Let me know
    Thanks in advance

    0 comments