CODEWITHSUNDEEP
sql-serverdatabaseazureazure-sql-database
SterlinkArcher
SterlinkArcher

Reputation: 731

Azure database firewall issues

I just tried to create a database on my SQL server and managed to do it. But I get the following error: 

The server you specified xxx.database.windows.net does not exist in 
any subscription in [email protected]. 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 dont have a support plan, strangely it worked couple of days ago when I created a database which I was able to connect to.

It also says check the Microsoft.SQLServer.ConnectionDlg.core

Upvotes: 5

Views: 10902

Answers (3)

Mihkel Tiganik
Mihkel Tiganik

Reputation: 21

Double check your IP. For me that last number in my IP changed. If it keeps changing consider to put your IP as a range

Upvotes: 0

Dan Rediske
Dan Rediske

Reputation: 852

It seems that you outpaced the creation of the database when you were trying to connect. The error indicates the database doesn't exist (yet).

If you started in the portal, after initiating the create database process there is some delay where your database is unavailable- provisioning is not immediate, though it is generally very quick. You will receive a notification in the portal when the creation is complete.

Additionally: You were correct in that you will need to add the IP you want to connect from to the firewall, though the text of the error is not indicating a firewall issue. For more on Firewall Rules/Settings in Azure SQL.

For more general reading: Getting started with SQL on the Azure Portal.

Upvotes: 2

SterlinkArcher
SterlinkArcher

Reputation: 731

Well after some investigation I came to the conclusion that it's a bugg that is in Azure. I added my IP-address in the confiugartion windows for the database in the Azure Portal, checked if SQL was visible and some other settings. All of a sudden it just started working again. I think this can be disregarded as an solvable issue.

  1. Check your configuration of the database to see IP's that are allowed to connect through the firewall.
  2. Check if database and SQL is visible under the SQL Server settings in Azure portal.

Upvotes: 5

Related Questions