Can't connect to Azure Sql with SSMS or Azure Data Studio

John Marsing 0 Reputation points
2024-05-20T16:55:23.8433333+00:00

I used to be able to get to me Azur Sql database via SSMS (Sql Server Management Studio) or Azure Data Studio but now I can't.

Firewall rule error

The server you specified x does not exist in any subscription in y Either you have signed in with an incorrect account or your server was removed from subscription(s) in this account. Please check your account and try again.

I don't know what changed but I've been able to do this for years.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,183 questions
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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,756 Reputation points
    2024-05-21T05:04:25.1+00:00

    Hi @John Marsing,

    you have signed in with an incorrect account or your server was removed from subscription(s) in this account. Please check your account and try again.

    Like the error message said, please have a check your configuration of the database to see IP's that are allowed to connect through the firewall.

    Check if database and SQL is visible under the SQL Server settings in Azure portal.

    Also check this thread to see if it is helpful.

    https://stackoverflow.com/questions/41612250/account-has-no-subscriptions-when-adding-new-firewall-rule-from-sql-server-man

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  2. GeethaThatipatri-MSFT 28,932 Reputation points Microsoft Employee
    2024-05-21T11:08:32.8266667+00:00

    @John Marsing We have and active outage and this is for specific range of IP addresses.
    The issue is caused by a specific IP range [ From="48.216.0.0" To="48.219.255.255" ] not being recognized as Azure resources by SQL DB, which blocks the traffic from other services.

    This issue could be mitigated by adding explicit rules for the affected IP addresses in your SQL DB firewall settings by following the DOC IP firewall rules - IP firewall rules - Azure SQL Database and Azure Synapse Analytics | Microsoft Learn

    If you continue to notice impact and need further assistance, please create a support ticket

    Our engineers are proactively working to resolve the issue.

    Regards

    Geetha

    0 comments