Results 1 to 4 of 4

Thread: MS SQL Server on SLES 12 SP4 - Error code 0x2746

Hybrid View

  1. #1

    MS SQL Server on SLES 12 SP4 - Error code 0x2746

    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.

  2. #2

    Re: MS SQL Server on SLES 12 SP4 - Error code 0x2746

    Quote Originally Posted by AndersG View Post
    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?

    Code:
    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...ql-server-2017

    Then:

    Code:
    sqlcmd -S 10.10.10.10 -U SA -P password
    localhost will not work

  3. Re: MS SQL Server on SLES 12 SP4 - Error code 0x2746

    According to this one you can try to downgrade the openssl package.

  4. Re: MS SQL Server on SLES 12 SP4 - Error code 0x2746

    I don't believe Microsoft has gone beyond SUSE 12 SP2 for a supported platform yet. https://docs.microsoft.com/en-us/sql...ql-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...ql-server-2017

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •