My SQL Server resource on Azure Portal is disabled

Question

My SQL Server resource on Azure Portal is disabled

Gabriel Balinisteanu 0

I wanted to login into my SQL Server using SSMS and the connection completely failed, I checked the Azure Portal and I found out on my SQL Server resource that in Overview tab is a Header orange high alert, called Disabled.

I connected with success on my SQL Server and worked fine inside my database a couple of days ago and it work perfectly.

What is going on? I pay 5$/month for this service. Is there any maintenance operation ongoing on Central US that I should know about?

Please see attached my proof.

I tried also your AI support and it completely failed to deliver an optimal solution.

What is the solution for this issue?

Thank you.

SQL Server Resource Disabled on Azure Portal..JPG

Login failed in SSMS to my SQL Database Resource.JPG

Mahesh Kurva 5,210 Reputation points Microsoft External Staff Moderator

2024-12-02T16:51:35.85+00:00

Hi @Gabriel Balinisteanu,

Just checking in to see if the below answer provided by @Azar helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Mahesh Kurva 5,210 Reputation points Microsoft External Staff Moderator

2024-12-02T16:51:35.85+00:00

Hi @Gabriel Balinisteanu,

Just checking in to see if the below answer provided by @Azar helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Azar 29,520 MVP Volunteer Moderator

Hi there Gabriel Balinisteanu

Thanks for using QandA platform

First, it's a good idea to check Azure Service Health for any ongoing outages or maintenance in the Central US region. Additionally, verify that your subscription is active and that there are no billing issues—sometimes unpaid charges or suspended subscriptions can result in resources being disabled.

Another step you could try is restarting the SQL Server directly from the Azure Portal to see if that resolves the issue.

If nothing works, I recommend reaching out to Azure Support they will help you with this, the link is below,

https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/overview

If this helps kindly accept the answer thanks much.

Gabriel Balinisteanu 0 Reputation points

2024-11-28T15:07:59.9333333+00:00

Dear Azar,

I checked first Azure Services Health based on your advice and there are no active issues worldwide, all locations look healthy.

But, I discovered on my subscription plan on the overview tab a red alert message :

"You've used all your free credit. Upgrade to keep going with your account".

I know this because I have a free trial account and I used all resources for an academic project, but yesterday I had still 14 days valid from this trial.

What is the point? If I used all the resources (free 200$) to practice Cloud and I still have 14 days of trial period, why I cannot use my resources based on that? What is the purpose for creating and consuming this resources?

I still should have the option to use them within 14 days left. It does not make any sense.

What should I do know? I am running an academic project over the E-learning platform from Linkedin and I need to use this resources.

That is not fair to upgrade to pay-as-you-go.

See my attached files.

You've used all your free credit. Please upgrade your subscription plan..JPG

Azure Service Health - There are no active issues - Worldwide healthy locations.JPG

Thank you.
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator

2024-11-28T22:10:49.3+00:00

If you had 200 dollars to spend in a month, and you spent them in a fortnight, you have no dollars left for the rest of the month.

I'm not sure what your thinking is, but the database and other resources you create come with a cost by the minute. It is not that you create a database for 50$ and that's a one-time cost.

It's a hard lesson about the cloud, but it's an important one: Keep an eye on your costs in the cloud.
Gabriel Balinisteanu 0 Reputation points

2024-11-28T23:24:43.58+00:00

I did not spent them without a reason, I spent them based on a specific training DP 203 from Microsoft based on the content over the 14 days, the resources were necessary to be created to go over the content of the course. So, I was not playing with that credit, I was going on according with the content and the necessary resources that you need to work for every lesson. I hope I was very clear to you regarding my intention to consume these resources.

However, I will take in consideration your advice regarding the costs surveillance.

Thank you for your support.
Azar 29,520 Reputation points MVP Volunteer Moderator

2024-11-29T13:17:45.9966667+00:00

Hi there, checking if this answer helped, if it did kindly accept the answer thanks much.
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator

2024-11-29T22:31:09.18+00:00

I did not spent them without a reason, I spent them based on a specific training DP 203 from Microsoft based on the content over the 14 days, the resources were necessary to be created to go over the content of the course.

I realise that it is frustrating of only getting half-way before you ran out of credits.

Now, I don't exactly know what resources you created. But there are ways to keep down the cost. For Azure SQL Database, you can go with an S0 database or even Basic Edition. They are very cheap, but also quite slow.You can also go with Serverless. They are great if you only work a few hours per day and then stop them. Once they are stopped, you only pay for storage. With such a database, you get better speed. Except for the first connection of the day, since there is a startup time.

It's also important to draw all sliders to the left to keep down costs.

A great thing with the cloud is that if you want a hot machine for some performance test or whatever, you can scale up. And then scale down when you are done.
Mahesh Kurva 5,210 Reputation points Microsoft External Staff Moderator

2024-12-03T17:26:54.8666667+00:00

Hi @Gabriel Balinisteanu,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

My SQL Server resource on Azure Portal is disabled

1 answer

Your answer