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-...
Besides the article that we wrote: Lesson Learned #161: Error 0 - No such host is known in Azure SQL Managed Instance - Microsoft Commu... this situation also could happen if you are using Private Endpoint Lesson Learned #238: Configuring Private Endpoint Connections in Azure SQL Managed Instance - Micros...
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!
