question

enze avatar image
0 Votes"
enze asked ·

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

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

KamleshKumar avatar image
0 Votes"
KamleshKumar answered ·

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

71540-image.png

Regards,
Kamlesh Kumar



image.png (9.1 KiB)
·
10 |1000 characters needed characters left characters exceeded

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

enze avatar image
0 Votes"
enze answered ·

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

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

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

0 Votes 0 ·
enze avatar image enze KamleshKumar ·

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 Votes 0 ·

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 Votes 0 ·
Show more comments
enze avatar image
0 Votes"
enze answered ·

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

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

enze avatar image
0 Votes"
enze answered ·

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

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