Blog Post

Azure Database Support Blog
1 MIN READ

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

Jose_Manuel_Jurado's avatar
Oct 26, 2022

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!

Published Oct 26, 2022
Version 1.0
No CommentsBe the first to comment