I have been trying to get SQL Server 2017 running on my Ubuntu 18.04 LTS laptop and I've been running into problems. I have gotten SQL Server to install correctly and start running by following the directions at https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-2017. However, I can't connect to SQL Server using the command:

sqlcmd -S localhost -U SA -P '<YourPassword>'

When I try, I get the 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.

When I check the status of mssql-server, it returns:

mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2019-08-12 18:44:37 EDT; 12min ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
 Main PID: 973 (sqlservr)
    Tasks: 158
   CGroup: /system.slice/mssql-server.service
           ├─ 973 /opt/mssql/bin/sqlservr
           └─1218 /opt/mssql/bin/sqlservr

Does anyone know what is happening? Is there a fix or a walkthrough that would help me do a fresh install? I've tried to install it a bunch of different ways and always get stuck with the same errors.

Thanks in advance for any advice,


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.