BAM Configuration error BizTalk 2020

Question

question

enze asked · Feb 24 at 09:36 AM

BAM Configuration error BizTalk 2020

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

biztalk-server-all

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-02-24T13:40:49.843Z

KamleshKumar answered · Feb 24 at 01:40 PM

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://docs.microsoft.com/en-us/biztalk/install-and-config-guides/configure-biztalk-server#custom-configuration

Regards,
Kamlesh Kumar

image.png (9.1 KiB)

·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2021-03-03T09:36:15.65Z

enze answered · Mar 03 at 09:36 AM

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

· 5 ·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KamleshKumar · Mar 03 at 10:05 AM

Yes, you have to do this on an SQL machine.

0 ·

enze KamleshKumar · Mar 04 at 10:38 AM

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 ·

KamleshKumar enze · Mar 04 at 12:15 PM

Did you verify if integration services installed in your SQL server, kindly check and share the screenshot as I shared previously?

Also, if that is done then please create the SSIS catalog. Refer to below link,

https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver15#create-the-ssis-catalog

Note: I recently fixed this issue on one of the VM where installed BT2020

0 ·

Show more comments

Answer 3 · 2021-03-04T10:39:02.187Z

enze answered · Mar 04 at 10:39 AM

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

·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 4 · 2021-03-04T14:03:10.513Z

enze answered · Mar 04 at 02:03 PM

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

·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question