cannot access to my azure sql server via azure data studio

Zhuoqiong Mo 40 Reputation points
2024-05-29T09:03:15.3433333+00:00

I have a remote connection between azure data studio and azure sql server and it works pretty well before.

I cannot access to my azure sql server via azure data studio and power bi since yesterday. I check my ip address and my instant name, everything is correct and I could access to my azure synapse studio. where is the problem?

below is the error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat.)

many thanks

Joan

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,201 Reputation points Microsoft Employee
    2024-05-30T03:44:33.4033333+00:00

    Hi Zhuoqiong Mo •,

    Welcome to Microsoft Q&A forum.

    As I understand, you could not connect to Azure SQL Server via Azure Data Studio, and it was working fine earlier.

    Please check below points:

    • Check if the password has been reset for the server?
    • Ensure that you are using the correct server name. It should be in the format: your_server_name.database.windows.net
    • If your Azure SQL Server is configured to allow remote connections.
    • Check Firewall rules and network connectivity working fine.
    • Check if the same is accessible via Query Editor in Azure Portal so that we can understand if the issue exists between server and ADS.
    • Try using SSMS if the same server is logged in from there and issue exists across all tools or only SSMS.
    • Try updating ADS to the latest version and retry.

    Let us know if above helped. If not, please share configuration details of your server so that we can replicate the same and try at our end.

    Thanks.

    0 comments