How to solve this firewall rule error

효준 이 25 Reputation points
2023-04-17T02:53:16.06+00:00

에저데이터스튜디오 방화벽 오류

Azure SQL Database
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.
100 questions
{count} vote

Accepted answer
  1. Oury Ba-MSFT 16,886 Reputation points Microsoft Employee
    2023-04-18T17:45:21.2166667+00:00

    효준 이 Thank you for reaching out. If you are getting the error message "the server you specified does not exist in any subscription" when trying to create a firewall rule in Microsoft Azure, it may indicate that the server's name or IP address that you are specifying is incorrect or not associated with the subscription you are currently working with. Please check the following.

    1. Verify that the server is associated with the correct subscription as suggested above by Nandan Hegde. If you have multiple Azure subscriptions, make sure that the server you are trying to connect to is associated with the same subscription that you are currently working with. You can check this by going to the Azure portal and navigating to the "All resources" section, where you should see a list of all resources associated with your subscription.
    2. Check that the server's firewall settings allow incoming connections from your IP address or range. You can do this by going to the Azure portal, navigating to the server's settings, and then checking the firewall settings.
    3. Check that the server is running and that you can access it from your network. You can try pinging the server or connecting to it using a remote desktop connection to verify that it is accessible. Please comment below and let us know the results. Regards, Oury
    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Nandan Hegde 29,901 Reputation points MVP
    2023-04-17T04:35:29.79+00:00

    Based on the error message, can you please confirm whether the SQL server is still present in the subscription stated above? It seems that the server might have been deleted or moved to another subscription User's image

    0 comments No comments