locked
Unable to configure BAM Tools RRS feed

  • Question

  • Hi All,

    Getting below error while configuring BAM Tools in BizTalk multi-server environment.

    Microsoft SQL Server Data Transformation Services (DTS) 2016 or higher for BAM Archiving is not installed on the local machine.  Please install Microsoft SQL Server 2016 Integration Services. (Sql2016)

    Followed this solution also,still getting same error.

    https://biztalktalk.wordpress.com/2013/02/14/unable-to-configure-bam-tools/

    Thanks,

    VJ.

    Tuesday, June 6, 2017 9:34 PM

Answers

  • No, Management Studio is not required, it's the SQL Client you have to install from the SQL Server media.

    Run SQL Server Setup and select at least SQL Server Client Tools Connectivity.

    • Marked as answer by VVJ12 Tuesday, June 6, 2017 10:57 PM
    Tuesday, June 6, 2017 10:44 PM
    Moderator

All replies

  • If this is a multi server setup, you have to install the SQL Client on the BizTalk Computers as well.
    Tuesday, June 6, 2017 9:36 PM
    Moderator
  • Yes it is multi server.

    Do you mean,I have to install SSMS in BizTalk Server.

    Tuesday, June 6, 2017 9:48 PM
  • No, Management Studio is not required, it's the SQL Client you have to install from the SQL Server media.

    Run SQL Server Setup and select at least SQL Server Client Tools Connectivity.

    • Marked as answer by VVJ12 Tuesday, June 6, 2017 10:57 PM
    Tuesday, June 6, 2017 10:44 PM
    Moderator