i have a 16.04 version Ubuntu. I recently installed MSSQL server in the system. The version is SQL express 2019. Everything was ok during the installation . I followed the instructions in this link: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15
I Have 4gb of Memory and space in HD (12 gb) in the opt folder i see the MSSQL folder and MSSQL-TOOLS folder where i have the tool mssql-scmd
When i check the status seems ok:
mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor pre
Active: active (running) since Sun 2020-10-11 20:23:32 BST; 1h 39min ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 998 (sqlservr)
CGroup: /system.slice/mssql-server.service
├─ 998 /opt/mssql/bin/sqlservr
└─2485 /opt/mssql/bin/sqlservr
i try to access as per instructions with this command line
sqlcmd -S localhost -U SA -P '<YourPassword>'
(i set my password and click return)
Unfortunately in return i got:
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'SA'..
If this is the problem any idea how to solve it? not sure if i can find that driver easily?
Thanks in advance Paolo