Is there any transactional SQL for creating firewall rule using sp_set_firewall_rule in Azure MI

Question

Hi Team,

Can you please let us know, is there any transactional SQL for creating firewall rules using sp_set_firewall_rule in Azure Managed Instance?

 

Thanks,

Abhishek Modi

Answer 1

Hello,

Note that the Server-level firewall rules do not apply to Azure SQL Managed Instance.
Ref : https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-create-server-level-portal-quickstart?view=azuresql

The sp_set_firewall_rule only applies to Azure SQL Database Azure Synapse Analytics

Hope this helps :)

Answer 2

Hello,

Note that Server-level firewall rules do not apply to Azure SQL Managed Instance.
Ref : https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-create-server-level-portal-quickstart?view=azuresql

The sp_set_firewall_rule only applies to Azure SQL Database Azure Synapse Analytics

Hope this helps.