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