Database server down, cannot connect to it from Query Editor (or from anywhere else)

Question

Database server down, cannot connect to it from Query Editor (or from anywhere else)

Adis Mackovic 20

Azure database server is down and I cannot connect to it from anywhere - neither from Query Editor, not from local SSMS nor from App Service.

I checked login creds, they are correct, Security->Networking is set up correctly (Public network access: Selected networks, Allow Azure services and resources to access this server: True).

Server doesn't return on ping. I think it is missing DNS records.

nslookup from Kudu (Bash) returns NXDOMAIN.

Please see attached pictures as well.

This is a personal project so I don't have budget for Azure support.

User's image

viber_image_2025-11-26_11-40-25-339 82c8b5b9-81b2-466a-a67a-d6989349d1a6

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Kalyani Kondavaradala 4,600 Microsoft External Staff Moderator

Hi Adis Mackovic,

Thank you for your responses over private messages and for sharing the requested details.

I noticed that the server was deleted from your side. Earlier, I had requested you to create the server in a different region, and you later confirmed that you were able to connect successfully.

Just to clarify, the issue in the East US region is due to a capacity limitation, and additionally your current subscription has restrictions since it does not include paid support.

I hope this information helps. Please feel free to reach out if you have any further questions, we’re here to assist.

Kindly consider upvoting and accepting the answer so that it will help others who are facing similar challenges.

Thanks!

Kalyani

Adis Mackovic 20 Reputation points

2025-11-28T08:55:44.4933333+00:00

Hi Kalyani,

Just few corrections, I wasn't using East US, but Germany West Central (for old and new server).

Also, I deleted server and lost all the data - so I wouldn't consider this as a fix, because I couldn't migrate db from that broken server to a new one.

Anyway, thanks for your help, I will accept your answer so ticket is closed.

Best Regards,

Adis
Kalyani Kondavaradala 4,600 Reputation points Microsoft External Staff Moderator

2025-11-28T09:10:49.21+00:00

Hi, from your previous comments, I noticed that you tried to create a new server in the East US region, which failed. I wanted to inform you that there are certain restrictions on your subscription that are causing this issue.

Answer 2

Marcin Policht 69,460 MVP Volunteer Moderator

You need to explicitly allow inbound traffic from the IP address from which the connection originates - i.e. IP address associated with your home computer (just type in "what's my IP" in any search engine in your web browser) and the outbound IP address of the App Service resource.

Details at https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql and https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-create-server-level-portal-quickstart?view=azuresql

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Adis Mackovic 20 Reputation points

2025-11-26T12:13:40.91+00:00

I have done that already, but connection is dropped before getting to firewall:
Marcin Policht 69,460 Reputation points MVP Volunteer Moderator

2025-11-26T12:22:43.9633333+00:00

Select the option to Add your client IPv4 address instead. Depending on your location (and the way you access internet from your office), you might actually be using a range of IP addresses - so you might need to extend it by modifying start and end IPv4 address accordingly)

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin
Adis Mackovic 20 Reputation points

2025-11-26T12:26:41.51+00:00

Sorry, that's actually my client address which is whitelisted, which I tried to hide but forgot to hide on that button.
Marcin Policht 69,460 Reputation points MVP Volunteer Moderator

2025-11-26T12:28:56.25+00:00

That's the IP address you should be using

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin
Adis Mackovic 20 Reputation points

2025-11-26T12:36:18.58+00:00

And I am using that IP address. Sorry if I wasn't clear.
Marcin Policht 69,460 Reputation points MVP Volunteer Moderator

2025-11-26T12:49:35.3566667+00:00

Extend the range beyond a single IP. For example, if your IP address is 100.100.100.100, set the Start IPv4 address to 100.100.100.1 and End IPv4 address to 100.100.100.254

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin
Adis Mackovic 20 Reputation points

2025-11-26T12:58:04.56+00:00

Same thing again:
Marcin Policht 69,460 Reputation points MVP Volunteer Moderator

2025-11-26T13:25:11.4633333+00:00

Looks like your server name is not resolvable via DNS

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin
Adis Mackovic 20 Reputation points

2025-11-26T13:41:56.8066667+00:00

But it worked just fine for more than 3 months and suddenly it doesn't. Also, if I try to create new one, it allows it:

Do you have any suggestions what I could do, because I tried exporting db to a new db server and that fails as well:
Marcin Policht 69,460 Reputation points MVP Volunteer Moderator

2025-11-26T15:39:02.3233333+00:00

It appears that you're using the name that's not resolvable via DNS - > homy-sql.database.windows.net.

Server: dns.google

Address: 8.8.8.8

*** dns.google can't find homy-sql.database.windows.net.: Non-existent domain

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin
Adis Mackovic 20 Reputation points

2025-11-26T16:16:55.2866667+00:00

Is there anything I could do ?

Again, it used to work for more than 3 months just fine and suddenly it doesn't anymore.
Kalyani Kondavaradala 4,600 Reputation points Microsoft External Staff Moderator

2025-11-27T14:12:15.1166667+00:00

Hi Adis Mackovic,

Could you please provide the requested server details over Private message to investigate on this.
Adis Mackovic 20 Reputation points

2025-11-27T17:46:41.3266667+00:00

Even though it is not a solution, I had to delete server because nothing else worked. I created new one and it works fine, so I'll close this ticket.

Share via

Database server down, cannot connect to it from Query Editor (or from anywhere else)

1 additional answer

Your answer