-> I created an Azure SQL managed Instance and tried to connect to the public endpoint as given below,
-> Connection to the Managed Instance failed with below error,
TITLE: Connect to Server
Cannot connect to pg-mi-uks.public.780ac912e702.database.windows.net,3342.
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 – A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
-> Public endpoint provides the ability to connect to Managed Instance from the Internet without using VPN and is for data communication (TDS) only.
-> This option requires port 3342 to be open for inbound traffic. You will need to configure NSG rule for this port separately.
-> Once port 3342 was opened for in-bound traffic. We were able to connect to the managed instance without any issues.
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.