Forum Discussion

caiman's avatar
caiman
Copper Contributor
Jul 25, 2019

SQL Server 2019 on Ubuntu 18.04

Hi everyone,

I was able to install Developer preview of SQL Server 2019 on Ubuntu 18.04, and was using it smoothly for a week. Then, today I started receiving the following connection error while attempting sqlcmd:

 

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.

 

I reinstalled mssql-server from scratch, ran the configuration utility, but cannot connect to the server.

 

Did anyone experience something similar?

  • jswainst's avatar
    jswainst
    Copper Contributor
    Jul 26, 2019

    Yes, I am experiencing the same issue.

     

    I have tried reinstalling, as well as downgrading to a couple of past versions.

     

    It started as soon as I installed the latest version this morning.

  • Tejas Shah's avatar
    Tejas Shah
    Icon for Microsoft rankMicrosoft
    Jul 30, 2019

    The reason why you are having issues with this is because SQL Server 2017/2019 packages meant for Ubuntu 16.04 have a dependency on OpenSSL version 1.0. While Ubuntu 18.04 ships with OpenSSL version 1.1. Until we get a package meant for Ubuntu 18.04, you can follow the steps in following blog to and create links to libssl.so and libcrypto.so for version 1.0 into /opt/mssql/lib path. 

     

    https://techcommunity.microsoft.com/t5/SQL-Server/Installing-SQL-Server-2017-for-Linux-on-Ubuntu-18-04-LTS/ba-p/385983 

     

    Once the appropriate links are created, the connectivity to SQL Server should work. 

Share