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

Question

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.

Answer 1

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.

Answer 2

@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