I'm trying to set up a pay-as-you-go SQL Server on an Azure Virtual Machine. From what I've gathered, simply installing SQL on a VM won't allow me to use this pricing model. It seems like I need to utilize a marketplace image for a particular version of SQL Server on a corresponding Windows Server version. However, I'm not sure how to select the licensing option correctly. I began the setup with SQL Server 2022 on Windows Server 2022, but I can't find where to choose the licensing plan for pay-as-you-go. Is there a default setting I'm missing, or do I need to adjust something to switch to a 'normal' license?
3 Answers
When you're in the Azure portal, search for 'Azure SQL' and navigate to 'SQL Server on Azure VMs'. After selecting 'Create', you should be taken to the wizard where you can choose your specific image. Make sure to check the SQL Server License section; it should allow you to confirm your license status. But if you select 'no' there, it usually means pay-as-you-go is the default. Can you confirm if that’s how it looks on your setup?
I'm curious why you opted for a VM instead of using Azure SQL's PaaS options? They tend to be cheaper and more secure. But if you're tied to using IaaS for something like SCCM, that's understandable. Wish Azure made it easier for those needing serverless options!
Check out the Azure documentation on setting up SQL Server on VMs. It has a lot of helpful information on options and configurations you might need. Here's a link that should help: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview?view=azuresql
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically