Azure VPN P2S and Google router

hoover-hash123 6 Reputation points
2021-02-01T19:55:43.377+00:00

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 Database
Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,411 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sumarigo-MSFT 44,096 Reputation points Microsoft Employee
    2021-02-04T09:58:22.56+00:00

    @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.

    0 comments No comments