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

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

Leave a Reply to Toni Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s