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

Abhishek Modi (amodi) 0 Reputation points
2024-04-22T12:26:02.4033333+00:00

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

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
724 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Abhishek-MSFT 181 Reputation points Microsoft Employee
    2024-04-22T15:01:36.2233333+00:00

    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 :)

    0 comments No comments

  2. Abhishek-MSFT 181 Reputation points Microsoft Employee
    2024-04-22T15:03:28.0966667+00:00

    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.

    0 comments No comments