What does "No Access" mean, in Networking tab, while creating Azure SQL Server

Question

I kind of understand the other two options which is shown in Networking tab -> Connectivity Method - "Private Endpoint" and "Public Endpoint". However, I am unable to understand "No Access" option. As I am thinking if there is no access to SQL server why would I create it? I mean SQL server must at least be able to communicate with Application servers. Could you please help me understand the same or point me to a resource which explains it.

Answer 1

Hi @Anantha Subramanian ,

Thank you for posting your question in Microsoft Q&A platform and for using Azure Services.

For Azure SQL Database, "No Access" in Networking tab signifies only connections via private endpoints are allowed. All connections via public endpoints will be denied.

Here is the snippet which documents the Connectivity method "No Access"

Link for the same is : connectivity-settings

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification

Answer 2

The default for the Connectivity method setting is No access so that customers can connect by using either public endpoints (with IP-based server- level firewall rules or with virtual-network firewall rules) or private endpoints (by using Azure Private Link).
When Connectivity method is set to No access, only connections via private endpoints are allowed.

Once you create your Azure SQL Database, you can enable public network access for the logical server hosting your databases, by going to the Networking page in the Azure portal, choose the Public access tab, and then set the Public network access to Select networks.

From this page, you can add a virtual network rule, as well as configure firewall rules for your public endpoint. Create a firewall rule here. Make sure you allow access to Azure resources as shown below: