question

hoover-hash123 avatar image
0 Votes"
hoover-hash123 asked SumanthMarigowda-MSFT answered

Azure VPN P2S and Google router

Hello,

A member of our Team recently upgraded their home router to a Google Router (model GJ2CQ). This member can connect with the VPN, but they can no longer use SSMS to connect to our Azure Managed Instance SQL database which they had been able to do prior to the router upgrade.

This individual is not the only member to have experienced this issue with a Google router. Has anyone else dealt with this or something similar?

The error message received when attempting to access our Azure MI via SSMS is:

*Cannot connect to <>.

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.) (.Net SqlClient Data Provider)*

Any help would be greatly appreciated. Thanks!




azure-sql-databaseazure-vpn-gateway
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SumanthMarigowda-MSFT avatar image
0 Votes"
SumanthMarigowda-MSFT answered

@xiongNWN-8368 Welcome to Microsoft Q&A, Thank you for posting your query!

Firstly, apologies for the delay in responding here and any inconvenience this issue may have caused. This article lists troubleshooting techniques to use when you can't connect to an instance of the SQL Server Database Engine on a single server.

If the issue still persist, please share the screenshot of the error message. I would like to work closer on this issue

Hope this helps!

Kindly let us know if the above helps or you need further assistance on this issue.


Please don’t forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.