This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 64%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Unable to create Azure SQL VM; have tried three times and each fails on final step of creation. The VM's do then appear in resources, but attempting to RDP always fails ultimately. However non SQL VM creation works; the working VM and the three failed SQL VM's all have same spec, the only difference being provision of SQL Server on the SQL VMs. Does anyone have any guidance, perhaps the SQL Version image is corrupt; I tried with SQL Server 2019 Developer license. Unfortunately it seems there is no Microsoft support available on the free trial. Not a great start.. NB I have attempted this three times with three different VM's, all have had the same problem.
can you click on the more details which gives you more information as why this deployment have failed?
I have since deleted those failed VMs but tried again today, this time using SQL 2022 rather than 2019. It also failed to create VM after attempting to deploy for 53 minutes. On the more details states "
Previous stop-deallocate operation on VM /subscriptions/1419d9d7-2988-4137-9474-db124ce75783/resourceGroups/rg-Wildones/providers/Microsoft.Compute/virtualMachines/WildcatSQL1 did not complete yet. Please try stop-deallocating the VM again. You should be able to restart the VM after stop-deallocation succeeds." NB The VM it refers to is one of previous SQL VM's that also failed yesterday, and which I deleted before attempting to create this one.
As with the other failed VM's, this appears on my resource list, but RDP fails. So it is unusable despite being listed as a resource and consuming disk storage credit.
NB I have found that the Ubuntu Server with SQL Server 2019 image works. So now I just need to learn how to use Linux..
Hi Richard,
Please confirm that you are attempting to deploy SQL Server VM to a VM size with enough resources (RAM especially). I would start with a VM with 8GB RAM or higher and then if you want to try smaller sizes (e.g. 4GB or 2GB RAM) you can stop the VM and resize smaller.
Please click Accept Answer and upvote if the above was helpful.
Thanks.
-TP
Hi TP, I did try one with 8GB RAM I think. In any case this should be quite easy to recreate; just try to create a SQL Windows To be honest I think I am going to see if I can get by with an Ubuntu machine now, especially as I've already used a fair amount of the credit experimenting with windows SQL VM.
Hi Richard. I have created several SQL Server on Windows VM (of varying VM sizes) without any issue, both since you asked your question and prior. I have seen it fail to deploy in the past, but usually it is one-off whereby if I repeat deployment it succeeds.
I've not tried with 1GB RAM VM since that is way too low for current Windows Server versions and SQL Server based on experience.
What Azure region were you creating the VM in?