The server you specified .database.windows.net,1433 does not exist in any subscription in email

Iron Contributor

Hi All.
I have an application that is hosted in the azurewebsites.net. I had this configured sometime back and it still works.

As i can still login to the website which is connected to a sql azure db and still works

The db name is below (aspnetdb)
Initial Catalog=aspnet-BehaviouralManagement

Error when i try using Azure Data Studio/SSDT to connect to my database

The server you specified .database.windows.net,1433 does not exist in any subscription in email address. Either you have signed in with an incorrect account or your server was removed from subscription(s) in this account.

 

When i login to my azure portal i cant see it listed on my sql databases.
But the application still works.
I believe i can't setup the firewall since i can login to the database :(

Any ideas how i can fix this.

Thanks in Advance

3 Replies

@Patrick Rote 
Anyone from MS that can help
Why can't i connect to the DB anymore? The website is still connected but i can't find a way to manage the DB
Am i missing something?

 

Thanks

Hi @Patrick Rote 

 

You can follow these guidelines:
- 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.

 

I researched it and found some material that can help you.

https://stackoverflow.com/questions/41551102/azure-database-firewall-issues

 

Regards,

Marcos Guarnier