Share via

Windows 11 fails to see SQL Server over a VPN connection

José Damião 0 Reputation points
2023-11-14T12:34:34.88+00:00

I have Windows 11 computers, connecting to the office LAN using a VPN, that fail to see the SQL Server.
Everything was ok as of October 31st, however on November 6th the SQL Server was no longer visible to the Windows 11 computers. Between the two dates there was no need to connect using the VPN.

Testing using a Windows 10 computer everything works, VPN connects OK and the SQL Server is visible when adding a new ODBC connection.
For the Windows 11 computers the VPN connects ok but the SQL Server does not show when adding a new ODBC connection.

The scenario is as follows:

  • Dedicated server hardware (Intel Xeon CPU) with Windows Server 2022 Essentials and SQL Server 2019 Express. This is the only SQL Server on the LAN.
  • SQL Server listens in the defaut port.
  • Windows 11 computers with ODBC connections to the SQL Server, working ok inside the office LAN.
  • Using the VPN the server responds to "ping server_IP" and the name is resolved using "ping -a server_IP".

With the VPN connected and adding a new ODBC:

  • With Windows 10 the server name appears.
  • With Windows 11 the server name DOES NOT appear.

The office LAN connects to the Internet using ISP A and the VPN tests using both Windows 10 and Windows 11 were done using a different access using ISP A and from an access using ISP B.

I cannot write here either the server IP nor the name of the ISP without permission of the management, however the ISP should not the issue in the above scenario.

Thanks in advance

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,632 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
9,393 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,441 Reputation points Microsoft Vendor
    2023-11-15T08:42:02.72+00:00

    Hi @José Damião

    Do you mean when you add the ODBC connection, the server name doesn't appear automatically?

    Can the connection be successful when you enter the server name manually?

    I found some similar links, maybe you can use them as a reference:

    https://community.spiceworks.com/topic/2323685-add-an-odbc-connection-to-a-remote-site-over-a-vpn

    https://superuser.com/questions/1072484/cant-resolve-computer-names-over-vpn-only-ip-addresses

    Best regards,

    Aniya

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.