Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal

by

[UPDATE 17.03.2020: Microsoft has released SQL Server 2019 CU3 with an Ubuntu 18.04 repository. See: https://techcommunity.microsoft.com/t5/sql-server/sql-server-2019-now-available-on-ubuntu-18-04-supported-on-sles/ba-p/1232210 . I hope this is now fully compatible without any ssl problems. Haven’t tested it jet.]

Reverting to 14.0.3192.2-2 helps.

But it’s possible to solve the problem also using the method indicated by Ola774, not only in case of upgrade from Ubuntu 16.04 to 18.04, but on every installation of SQL Server 2017 on Ubuntu 18.04.

It seems that Microsoft now in cu16 messed up with their own patch for the ssl-version problems applied in cu10 (https://techcommunity.microsoft.com/t5/SQL-Server/Installing-SQL-Server-2017-for-Linux-on-Ubuntu-18-04-LTS/ba-p/385983). But linking the ssl 1.0.0 libraries works.

So just do the following:

  1. Stop SQL Server 

    sudo systemctl stop mssql-server

  2. Open the editor for the service configuration by

    sudo systemctl edit mssql-server

This will create an override for the original service config. It’s correct that the override-file, or, more exactly “drop-in-file”, is empty when used the first time.

  1. In the editor, add the following lines to the file and save it: 

    [Service]
Environment="LD_LIBRARY_PATH=/opt/mssql/lib"

  2. Create symbolic links to OpenSSL 1.0 for SQL Server to use: 

    sudo ln -s /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0 /opt/mssql/lib/libssl.so 
sudo ln -s /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0 /opt/mssql/lib/libcrypto.so

  3. Start SQL Server 

    sudo systemctl start mssql-server

More Related Contents:

  1. freeTDS not using its config
  2. Get first day of week in SQL Server
  3. What is the significance of 1/1/1753 in SQL Server?
  4. How to create jobs in SQL Server Express edition
  5. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  6. How to delete large data of table in SQL without log?
  7. Insert Update trigger how to determine if insert or update
  8. SQL Server: UPDATE a table by using ORDER BY
  9. What is the best way to truncate a date in SQL Server?
  10. Do I really need to use “SET XACT_ABORT ON”?
  11. What is a Trusted Connection?
  12. Understanding SQL Server LOCKS on SELECT queries
  13. Do while loop in SQL Server 2008
  14. How to find the port for MS SQL Server 2008?
  15. How do I create a multiple-table check constraint?
  16. How to convert number of minutes to hh:mm format in TSQL?
  17. Stored Procedure and Permissions – Is EXECUTE enough?
  18. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  19. Dynamically assign filename to excel connection string
  20. SQL Server Group by Count of DateTime Per Hour?
  21. Temporarily disable all foreign key constraints
  22. How to import a DBF file in SQL Server
  23. SQL Server Dependencies
  24. How can I insert binary file data into a binary SQL field using a simple insert statement?
  25. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Date range overlapping check constraint
  28. SQL Server 2008 can’t login with newly created user
  29. Update SQL with consecutive numbering
  30. Nested transactions in Sql Server

Leave a Comment