Getting Error while deploying the Azure Managed SQL Instance Pool

Question

1. Powershell script used to deploy the Instance pool

# Identify the SubnetId

$virtualNetwork = Get-AzVirtualNetwork -Name vnet-DB -ResourceGroupName databaselab

$miSubnet = Get-AzVirtualNetworkSubnetConfig -Name subnet-MI -VirtualNetwork $virtualNetwork

$miSubnetConfigId = $miSubnet.Id

# Create the instance pool

$instancePool = New-AzSqlInstancePool -ResourceGroupName databaselab -Name instancepool001 -SubnetId $miSubnetConfigId -LicenseType LicenseIncluded -VCore 8 -Edition GeneralPurpose -ComputeGeneration Gen5 -Location Eastus

<#

Error:

New-AzSqlInstancePool: Long running operation failed with status 'Failed'. Additional Info:'An instance pool with name 'instancepoolxxx' is busy with another ongoing operation'

Can anyone help me in resolving this issue?

Answer 1

Hello Varun

Welcome to Microsoft Q&A Platform.

Internal server errors use to be related to transient platform issues, can you try again or use a different region as test? For example takes Central US instead of East US in your case , if it works then check if some ongoing operation related to same running in East US region. Once the operation finishes, you can retry creating the instance pool again in that same region

Best regards,

---

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.