PDA

View Full Version : SLES 12 SP4 MS SQL Server on SLES 12 SP4 - Error code 0x2746



AndersG
28-Aug-2019, 15:22
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.

AndersG
28-Aug-2019, 17:25
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.

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

strahil-nikolov-dxc
17-Sep-2019, 06:35
According to this one (https://stackoverflow.com/questions/57265913/error-tcp-provider-error-code-0x2746-during-the-sql-setup-in-linux-through-te) you can try to downgrade the openssl package.

cisaksen
26-Sep-2019, 21:23
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