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,