Problem in connecting DB manager on Ubuntu 18 machine with SQL Server (cloud)

0

The situation:
I started looking after a PHP application implemented in Codeigniter 1.0 (Linux server) that accesses SQL Server 2008 databases (Windows server, in the cloud). I have a development machine, dual boot (DEV Ubuntu 18 and DEV Windows 10).

Where is the problem ?:
 In Ubuntu 18 DEV.

What is the problem?:
No Ubuntu 18 DEV database manager (Azure Data Studio, DBeaver or LibreOffice Base) can connect to the SQL Server that is in the cloud.

The Azure Data Studio error message (DEV Ubuntu 18):
"A network-related or instance-specific error occurred while establishing a connection to SQL Server." The provider is configured to allow remote connections. TCP Provider, error: 25 - Connection string is not valid) "

Observations: 1 - In Ubuntu DEV 18, the PHP application can connect with SQL Server in the cloud .

2 - In DEV Win 10 (same machine) the SSD BD manager can connect.

3 - The connection data used in Azure, DBeaver or LibreOffice Base (Ubuntu DEV environment 18) are the same as those used by SSMS;

4 - I already checked with the SQL Server (cloud) administrator for possible TCP and UDP port problems, but said that they are already released.

5 - I tested the connections of the Azure, DBeaver and Libreoffice managers with SQL Server on the same machine (localhost) in the Ubuntu DEV environment and are OK.

6 - The network used in the Windows DEV and Ubuntu 18 DEV environments is the same.

Thanks for the tips to solve this problem.

    
asked by anonymous 26.10.2018 / 19:52

0 answers