Fix That SQL Server 2019 Error on Ubuntu 18.04

Jim Kang
1 min readDec 2, 2019

So you’ve followed along the docs to install MSSQL server 2019 on ubuntu 18.04 and you’ve encountered the following error:

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection.

well, let’s get that fixed right away!

Reason Why it’s Not Working

TL;DR; SQL Server 2017/2019 have a dependency on OpenSSL v1.0, while Ubuntu 18.04…

--

--

Jim Kang

love writing bit sized programming memo, acoustic guitarist, proud daddy of 5 and great listener (to my kids)