Can not connect to remote sql server from ubuntu os

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.

https://learn.microsoft.com/sql/azure-data-studio

MIT License

7.56k stars 899 forks source link

Can not connect to remote sql server from ubuntu os #8812

Closed levinatan closed 1 year ago

levinatan commented 4 years ago

Azure Data Studio Version: 1.14.1
Sql Server 2008 R2 sp4 (10.0.6000)

Steps to Reproduce:

Try to connect to remote sql server (outside office subnet) from Azure data studio on ubuntu desktop 18.04 with sql log in.

Charles-Gagnon commented 4 years ago

FYI we do only officially support connections to SQL 2014+ - although generally connecting to older instances should work.

Regardless here's some questions I have to help troubleshoot :

When you say this is outside office subnet - are you able to reach this server with other applications (such as SSMS)? Where is this other server hosted? Generally if you're in an office network you will have limited access to outside resources (especially for non-standard external facing ports such as the ones SQL uses)
Do you get any errors when trying to connect?
How long are you waiting for the connection? Does it time out or do you cancel/quit before that?
Are you able to connect to other servers? If so what kind and where are they located?

levinatan commented 4 years ago

Ok i will write full description: A. Clients:
I install on same computer two OS:

windows 10 (192.168.x.2 - local network)
ubuntu 18.04 (192.168.x.2 - local network)

B. Servers: I have 2 sql server:

Dev server (192.168.x.3 - local network)
Production server (212.8.x.x outside my office)

C. FireWall: I have checkpoint router with firewall, that connect my office to internet and to my PRODUCTION SQL SERVER.

=============================== 1 From Windows Client to Dev Server = working perfect 2 From Windows Client to Production Server = working perfect 3 From UBUNTU Client to Dev Server = working perfect 4 From Windows Client to Production Server = NOT CONNECTING*

NO ERRORS THE LOADER ANIMATION ICON NOT STOPPING HIS SPINNING EVEN AFTER 10 MINUTES.

NOTES - About the firewall:

first we suspected that the firewall block our connections but after CHECKPOINT technician check more than 1 hour our device he found no problem.
SSMS - on windows it work perfect, no problems

cheenamalhotra commented 1 year ago

Hi @levinatan

Have you tried connecting with IP address instead of HostName? I'm wondering if app couldn't resolve IP address of the target server due to missing DNS information. Also let us know your Ubuntu machine is able to resolve DNS of production server by running nslookup.

cheenamalhotra commented 1 year ago

Closing due to inactivity