SQL Server 2019 on Ubuntu 18.04

%3CLINGO-SUB%20id%3D%22lingo-sub-772964%22%20slang%3D%22en-US%22%3ESQL%20Server%202019%20on%20Ubuntu%2018.04%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-772964%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI%20was%20able%20to%20install%20Developer%20preview%20of%20SQL%20Server%202019%20on%20Ubuntu%2018.04%2C%20and%20was%20using%20it%20smoothly%20for%20a%20week.%20Then%2C%20today%20I%20started%20receiving%20the%20following%20connection%20error%20while%20attempting%20sqlcmd%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESqlcmd%3A%20Error%3A%20Microsoft%20ODBC%20Driver%2017%20for%20SQL%20Server%20%3A%20TCP%20Provider%3A%20Error%20code%200x2746.%3CBR%20%2F%3ESqlcmd%3A%20Error%3A%20Microsoft%20ODBC%20Driver%2017%20for%20SQL%20Server%20%3A%20Client%20unable%20to%20establish%20connection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20reinstalled%20mssql-server%20from%20scratch%2C%20ran%20the%20configuration%20utility%2C%20but%20cannot%20connect%20to%20the%20server.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20anyone%20experience%20something%20similar%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775613%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%202019%20on%20Ubuntu%2018.04%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775613%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20I%20am%20experiencing%20the%20same%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20reinstalling%2C%20as%20well%20as%20downgrading%20to%20a%20couple%20of%20past%20versions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20started%20as%20soon%20as%20I%20installed%20the%20latest%20version%20this%20morning.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779629%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%202019%20on%20Ubuntu%2018.04%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779629%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20reason%20why%20you%20are%20having%20issues%20with%20this%20is%20because%20SQL%20Server%202017%2F2019%20packages%20meant%20for%20Ubuntu%2016.04%20have%20a%20dependency%20on%20OpenSSL%20version%201.0.%20While%20Ubuntu%2018.04%20ships%20with%20OpenSSL%20version%201.1.%20Until%20we%20get%20a%20package%20meant%20for%20Ubuntu%2018.04%2C%20you%20can%20follow%20the%20steps%20in%20following%20blog%20to%20and%20create%20links%20to%20libssl.so%20and%20libcrypto.so%20for%20version%201.0%20into%20%2Fopt%2Fmssql%2Flib%20path.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSQL-Server%2FInstalling-SQL-Server-2017-for-Linux-on-Ubuntu-18-04-LTS%2Fba-p%2F385983%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSQL-Server%2FInstalling-SQL-Server-2017-for-Linux-on-Ubuntu-18-04-LTS%2Fba-p%2F385983%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOnce%20the%20appropriate%20links%20are%20created%2C%20the%20connectivity%20to%20SQL%20Server%20should%20work.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

2 Replies

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.

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-... 

 

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