Azure data studio connection error?

2021-11-01T10:04:06.693+00:00

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 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 16,471 Reputation points Microsoft Employee
    2021-11-02T21:09:37.993+00:00

    Hi @Abdul Kadar, Ahamed Meeran Mydeen Thank you for replying back with screen shot.

    Could you please follow this documentation with step by step on how to connect to Azure SQL using Data Studio to make sure you are not missing anything.

    Please also make sure that client Ip is added in the firewall rule in Azure.

    Regards,
    Oury


  2. Oury Ba-MSFT 16,471 Reputation points Microsoft Employee
    2022-01-27T20:21:28.353+00:00

    @Mohammed Almuzaiqer could you please try to login by changing the server name.
    For example
    yourname@Stuff .com@my server name as username and password
    Please do also check out this thread which is similar to your issue
    https://learn.microsoft.com/en-us/answers/questions/389613/cannot-connect-to-azure-sql-db-using-ssms.html

    Regards,
    Oury