Azure SQL DB – An instance-specific error occurred while establishing a connection to SQL Server.

Posted on by

The full message when connecting to your Azure SQL Database is:

Reason: An instance-specific error occurred while establishing a connection to SQL Server. The public data endpoint on this server is not accessible. To connect to this server, use the Private Endpoint from inside your virtual network. (.Net SqlClient Data Provider)

error1

This message is “kind of” new because of couple of changes to the firewall / security settings within the Azure portal. By default, I generally block access via public routes.

deny

If, for example I switch that public settings to NO – I will NOT get the error and will be able to connect from SSMS. What you will be doing within your enterprise setup is the correct configuration of your virtual network (vnet) – so this is the area to focus on if you get above error.

vnets22

 

 

 

2 thoughts on “Azure SQL DB – An instance-specific error occurred while establishing a connection to SQL Server.”

  1. Pingback: Dew Drop – March 17, 2020 (#3155) | Morning Dew

  2. Hi, I have this error. My scanario is a webapp connected into a vnet/sbnet and an SQL server connected into the same vnet/subnet. The sql service enpoint are ready and succeded. Can you help me to find the problem?

    Like

    Reply ↓

Leave a reply to Toni Cancel reply