Lesson Learned #244: No such host is known connecting to Azure SQL Managed Instance Private Endpoint

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

Today, I worked on a service request where our customer got the following error: provider: TCP Provider, error: 0 - No such host is known.) (Microsoft SQL Server, Error: 11001)

 

TITLE: Connect to Server
------------------------------

Cannot connect to servername.virtualnetwork.database.windows.net.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) (Microsoft SQL Server, Error: 11001)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-11001-database-engine-error

 

Besides the article that we wrote: Lesson Learned #161: Error 0 - No such host is known in Azure SQL Managed Instance - Microsoft Community Hub this situation also could happen if you are using Private Endpoint Lesson Learned #238: Configuring Private Endpoint Connections in Azure SQL Managed Instance - Microsoft Community Hub 

 

In this case, please, check if the connection policy is configured to Redirect and change it to Proxy, due to, Private Endpoint only allows currently Proxy connection. 

 

Enjoy!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.