Why can't I create a SQL VM when a spending limit is set?

Question

Why can't I create a SQL VM when a spending limit is set?

Jon Mozley 35

I used to be able to create SQL Server VMs (e.g. SQL Server 2019 Developer on Windows Server 2019) using my Azure credits, however when I try this now it says "This virtual machine requires a subscription without any spending limit or temporary payment method set". Has something changed recently around this?

FWIW, it seems if I try an earlier OS (e.g. SQL Server 2014 SP3 Developer on Windows Server 2012 R2) then this restriction does not apply. It also doesn't seem to apply to Windows Server VMs without SQL Server.

KarishmaTiwari-MSFT 20,762 Reputation points Microsoft Employee Moderator

2023-06-13T01:59:15.53+00:00

@Jon Mozley I am checking on this and will get back shortly. Thanks.
Sandeep Nair 10 Reputation points

2023-06-13T23:26:19.04+00:00

Yes I am seeing the same problem. Something seems to have broken
Tom Plant 16 Reputation points

2023-06-14T09:43:14.0066667+00:00

I'm seeing this with multiple Windows Server variants (no SQL). All 2019 variants, 2016 (smalldisks are fine), and Server 2022 smalldisk Azure editions
Sandeep Nair 10 Reputation points

2023-06-14T11:31:55.7833333+00:00

yep only Windows 2022 works..all 2019 and before variants have the same issue
Leonardo Zanchetti Meneghini 0 Reputation points

2023-06-14T13:38:25.51+00:00

I see this with all VM SQL versions and Server 2019, 2016 versions:
dkrishnaveni-MSFT 1,956 Reputation points Microsoft Employee

2023-06-14T16:34:00.7833333+00:00

Hello @

I can understand you are facing issue when trying to create virtual machine with error to use different subscription without spending limit or remove spending limit. This is because the subscription used might be a benefit subscription( example: free trial subscription, visual studio or any other credit based subscription) where we have a fixed limit of credit per month and exhausting it will stop the resource by default. Using certain VM image will exhaust this limit even just with deployment due to the cost and this can stop the VM leading to disruption on service.

So, in order to proceed with same subscription, please follow the steps shared in the document section to remove the spending limit: https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/spending-limit#remove-the-spending-limit-in-azure-portal

Please also read through the same document section to understand why we need to remove the spending limit: https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/spending-limit#why-you-might-want-to-remove-the-spending-limit

Feel free to revert in case of any queries or concerns and I'll be happy to assist.

Kind Regards,

Divya.
KarishmaTiwari-MSFT 20,762 Reputation points Microsoft Employee Moderator

2023-06-14T17:35:31.0333333+00:00

Thanks all for reporting this. I have reached out to the internal team to confirm on this issue. I will share an update as soon as I hear back.
Jon Mozley 35 Reputation points

2023-06-15T08:19:33.0733333+00:00

Hi @dkrishnaveni-MSFT , I've never deployed a SQL VM before only to have it instantly consume the entire monthly credits allowed with my Visual Studio benefits, so unless the cost has increased dramatically I suspect it's something else causing the issue. And given that it's not going to be for production use, the disruption would not be an issue.

@KarishmaTiwari-MSFT thanks for the update, look forward to hearing more soon.
Leonardo Zanchetti Meneghini 0 Reputation points

2023-06-15T12:38:10.7033333+00:00

I am using a MSDN subscription and I have enough credits to use this resource. The problem remains today with all SQL Server VM versions.
Leonardo Zanchetti Meneghini 0 Reputation points

2023-06-15T18:25:49.7033333+00:00

I am using a MSDN subscription and I have enough credits to use this resource. The problem remains today with all SQL Server VM versions.
Yusuf Ranapurwala 35 Reputation points

2023-06-16T14:32:16.6466667+00:00

For me , Mainly issue occurred when selected windows 2016 OS , tried with windows 2022 OS it worked well.

Other services like recovery vault , azure backup , App services can be configured with the same visual studio subscription.
KarishmaTiwari-MSFT 20,762 Reputation points Microsoft Employee Moderator

2023-06-22T23:32:08.1666667+00:00

Hello all,

Thanks to each of you for reporting this issue. This issue has been fixed now as confirmed by the internal teams.

Issue summary: Customers were receiving this error when trying to create a VM with specific images
Error - [This virtual machine requires a subscription without any spending limit or temporary payment method set. Use a different subscription or update your subscription (requires account administrator privileges) at Account Center to continue]

This issue has been resolved. Customers should be able to create Windows Server, Windows 10, Windows 11 offers without seeing this error now. If anyone is still seeing this issue, please let me know in the comments.

Regarding SQL offers, internal team confirmed that -
Due to SQL Server licensing rules, SQL Server Enterprise, Standard, and Web editions are not available in MSDN/Free accounts. We are in the process of making Developer and Express edition images on all versions of SQL Server/Windows (and free Linux distros) available in Free accounts.

1 answer

Your answer

KarishmaTiwari-MSFT 20,762 Reputation points Microsoft Employee Moderator

2023-06-13T01:59:15.53+00:00

@Jon Mozley I am checking on this and will get back shortly. Thanks.
Sandeep Nair 10 Reputation points

2023-06-13T23:26:19.04+00:00

Yes I am seeing the same problem. Something seems to have broken
Tom Plant 16 Reputation points

2023-06-14T09:43:14.0066667+00:00

I'm seeing this with multiple Windows Server variants (no SQL). All 2019 variants, 2016 (smalldisks are fine), and Server 2022 smalldisk Azure editions
Sandeep Nair 10 Reputation points

2023-06-14T11:31:55.7833333+00:00

yep only Windows 2022 works..all 2019 and before variants have the same issue
Leonardo Zanchetti Meneghini 0 Reputation points

2023-06-14T13:38:25.51+00:00

I see this with all VM SQL versions and Server 2019, 2016 versions:
dkrishnaveni-MSFT 1,956 Reputation points Microsoft Employee

2023-06-14T16:34:00.7833333+00:00

Hello @

I can understand you are facing issue when trying to create virtual machine with error to use different subscription without spending limit or remove spending limit. This is because the subscription used might be a benefit subscription( example: free trial subscription, visual studio or any other credit based subscription) where we have a fixed limit of credit per month and exhausting it will stop the resource by default. Using certain VM image will exhaust this limit even just with deployment due to the cost and this can stop the VM leading to disruption on service.

So, in order to proceed with same subscription, please follow the steps shared in the document section to remove the spending limit: https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/spending-limit#remove-the-spending-limit-in-azure-portal

Please also read through the same document section to understand why we need to remove the spending limit: https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/spending-limit#why-you-might-want-to-remove-the-spending-limit

Feel free to revert in case of any queries or concerns and I'll be happy to assist.

Kind Regards,

Divya.
KarishmaTiwari-MSFT 20,762 Reputation points Microsoft Employee Moderator

2023-06-14T17:35:31.0333333+00:00

Thanks all for reporting this. I have reached out to the internal team to confirm on this issue. I will share an update as soon as I hear back.
Jon Mozley 35 Reputation points

2023-06-15T08:19:33.0733333+00:00

Hi @dkrishnaveni-MSFT , I've never deployed a SQL VM before only to have it instantly consume the entire monthly credits allowed with my Visual Studio benefits, so unless the cost has increased dramatically I suspect it's something else causing the issue. And given that it's not going to be for production use, the disruption would not be an issue.

@KarishmaTiwari-MSFT thanks for the update, look forward to hearing more soon.
Leonardo Zanchetti Meneghini 0 Reputation points

2023-06-15T12:38:10.7033333+00:00

I am using a MSDN subscription and I have enough credits to use this resource. The problem remains today with all SQL Server VM versions.
Leonardo Zanchetti Meneghini 0 Reputation points

2023-06-15T18:25:49.7033333+00:00

I am using a MSDN subscription and I have enough credits to use this resource. The problem remains today with all SQL Server VM versions.
Yusuf Ranapurwala 35 Reputation points

2023-06-16T14:32:16.6466667+00:00

For me , Mainly issue occurred when selected windows 2016 OS , tried with windows 2022 OS it worked well.

Other services like recovery vault , azure backup , App services can be configured with the same visual studio subscription.
KarishmaTiwari-MSFT 20,762 Reputation points Microsoft Employee Moderator

2023-06-22T23:32:08.1666667+00:00

Hello all,

Thanks to each of you for reporting this issue. This issue has been fixed now as confirmed by the internal teams.

Issue summary: Customers were receiving this error when trying to create a VM with specific images
Error - [This virtual machine requires a subscription without any spending limit or temporary payment method set. Use a different subscription or update your subscription (requires account administrator privileges) at Account Center to continue]

This issue has been resolved. Customers should be able to create Windows Server, Windows 10, Windows 11 offers without seeing this error now. If anyone is still seeing this issue, please let me know in the comments.

Regarding SQL offers, internal team confirmed that -
Due to SQL Server licensing rules, SQL Server Enterprise, Standard, and Web editions are not available in MSDN/Free accounts. We are in the process of making Developer and Express edition images on all versions of SQL Server/Windows (and free Linux distros) available in Free accounts.

Answer 1

KarishmaTiwari-MSFT 20,762 Microsoft Employee Moderator

@Jon Mozley

Thanks to all of you for reporting this issue. This issue has been fixed now as confirmed by the internal teams.

Issue summary: Customers were receiving this error when trying to create a VM with specific images
Error - [This virtual machine requires a subscription without any spending limit or temporary payment method set. Use a different subscription or update your subscription (requires account administrator privileges) at Account Center to continue]

Customers should be able to create Windows Server, Windows 10, Windows 11 offers without seeing this error now.

Regarding SQL offers, internal team confirmed that -
Due to SQL Server licensing rules, SQL Server Enterprise, Standard, and Web editions are not available in MSDN/Free accounts. We are in the process of making Developer and Express edition images on all versions of SQL Server/Windows (and free Linux distros) available in Free accounts.

If anyone is still seeing this issue, please let me know in the comments and I can investigate further. Thanks.

André Silva Cardoso 0 Reputation points

2023-07-25T09:46:19.83+00:00

Hi,

I'm seeing this error on VS 2022 (MS Dev Box). It's the first time I'm trying DevBox on Azure, so I don't know if it's supposed to work with VS Premium subscription...

Thanks in advance
Titus van Houwelingen 5 Reputation points

2023-08-18T12:31:57.16+00:00

I still have this issue TODAY with all images that contain Visual Studio.
(I have a VS Enterprise account).
Plenty of credit. So the excuse used in another thread about this issue that simply deploying such a VM would exceed the spending limit at once is not applicable here.

I tested this on multiple accounts: same issue.

I cannot solve it myself by removing the spending limit as my employer (who manages this subscription) will not allow it.

As I see this issue is already occurring for over 2 months, please fix this fast.

Thanks.

Share via

Why can't I create a SQL VM when a spending limit is set?

1 answer

Your answer