Forum Discussion
The server you specified .database.windows.net,1433 does not exist in any subscription in email
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 RoteIron Contributor
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
- mguarnierCopper Contributor
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
- Patrick RoteIron Contributor
mguarnier thanks for the response . Will have a look