Hi @Nandan Hegde Thank you for posting your question on Microsoft Q&A. Only the server-level principal login created by the provisioning process can delete server level firewall rules. The user must be connected to the master database to execute sp_delete_firewall_rule.
To be able to create and manage IP firewall rules for the Azure SQL Server, you will need to either be:
- In the SQL Server Contributor role
- In the SQL Security Manager role
- The owner of the resource that contains the Azure SQL Server
Hi @Nandan Hegde I haven't heard back from you and would like to check with you if the above answer was helpful. Please let us know