BizTalk Accelerator for HL7 failed to connect SQL

vivek k 1 Reputation point
2021-02-13T06:54:57.917+00:00

Hi All,

I installed BizTalk 2020 enterprise edition successfully in Sql server 2019 enterprise edition cluster environment. But using the same user account when installing the BizTalk HL7 accelerator throwing error like 'failed to connect the sql server. Start the sql server to correct the problem'. Even the test connection throwing the same error.

Sql server is up and running and the user through which I am installing the HL7 have the BizTalk administrator privilege and also the user as sql sysadmin rights.

Could anyone help me on this?

Thanks,
Vivek

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
356 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. EE 1 Reputation point
    2022-03-15T19:46:11.137+00:00

    Hi Vivek,

    We had the same issue. Based on our investigation, it needs SQL Server 2012 Native Client component to be installed first. It can be found at https://www.microsoft.com/en-us/download/details.aspx?id=50402

    Once downloaded and installed, everything should be fine.

    0 comments No comments