microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
9.73k stars 8.78k forks source link

Azure SQL Managed Instance sample script for Attach-vpn-gateway fails as VPN SKU is deprecated #1281

Open luis-aranda opened 2 months ago

luis-aranda commented 2 months ago

While following the instructions on this QuickStart to configure a point-to-site connection to Azure SQL Managed Instance from on-premises https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-to-site-p2s-configure?view=azuresql

The deployment fails with the error "New creations for Standard or HighPerformance sku is not supported." image

The underlying ARM template that is hosted on this repository is deploying using the deprecated Standard SKU https://github.com/microsoft/sql-server-samples/blob/master/samples/manage/azure-sql-db-managed-instance/attach-vpn-gateway/azuredeploy.json image

The VPN Gateway SKU has been deprecated as per this article. https://learn.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-vpn-faq#sku-deprecate image