Has anyone succeded in getting it to work? I get as far as it starting but cannot connect:
sle12sql2017:/opt/mssql/lib # sqlcmd -S 1.1.1.1 -U sa -P *******
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.
Other info on the web hint to openssl incompatibilities and suggest installing an older version, but it does not help. Above command CAN connet to other SQL Servers running on other machines.
[QUOTE=AndersG;58380]Has anyone succeded in getting it to work? I get as far as it starting but cannot connect:
sle12sql2017:/opt/mssql/lib # sqlcmd -S 1.1.1.1 -U sa -P *******
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.
Other info on the web hint to openssl incompatibilities and suggest installing an older version, but it does not help. Above command CAN connet to other SQL Servers running on other machines.[/QUOTE]
FWIW. Installing an older version on SLES 12 SP2 seems to work though?
sudo zypper addrepo -fc https://packages.microsoft.com/config/sles/12/mssql-server-2017.repo
sudo zypper --gpg-auto-import-keys refresh
sudo zypper install -y mssql-server=14.0.3192.2-2
sudo /opt/mssql/bin/mssql-conf setup
then install the tools as per: https://docs.microsoft.com/sv-se/sql/linux/quickstart-install-connect-suse?view=sql-server-2017
Then:
sqlcmd -S 10.10.10.10 -U SA -P password
localhost will not work
According to this one you can try to downgrade the openssl package.
I don’t believe Microsoft has gone beyond SUSE 12 SP2 for a supported platform yet. https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-suse?view=sql-server-2017
I know there were packages for MS authentication in SUSE12 SP2 that were removed in SUSE12 SP3. Not sure if that was resolved.
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication?view=sql-server-2017