Not able to connect to SQL server over VPN, DNS issue only in explorer.

Question

I've set up a VPN connection to our company server from a new windows 11 setup using the windows VPN client. Settings are the same as another computer in the same (remote) network.

VPN is setup with this PowerShell command :

Add-VpnConnection -Name "<name>" -ServerAddress "<address>" -RememberCredential -AuthenticationMethod MSChapv2 -SplitTunneling -DnsSuffix "<domain name>"

I've used this setting on different computers, and they all worked fine. (SQL connection and Drive mapping)

On the new system (DELL Latitude 5530, Win11 Pro 22H2 Build 22621.521) i run into the following issues.

VPN connects fine, no issues there.

I can ping the servers from the command prompt with server name and IP-address without issues. (DNS works)

File explorer connects to the server shares when I use the Ip-address, but not with the server's name. (Looks like no DNS)

SQL server clients are unable to connect to the SQL server through VPN.

RDP to any of the servers fails through VPN, even if I use the ip-address.

The other computer (Surface Go3, Win11 Home 21H2 Build 22000.1042) does not have these issues, everything works as expected.

I've searched about everything, reinstalled windows, used several connections (direct, WiFi) compared all the settings, Ipconfig /all shows the same values etc.

What can be a solution for this issue?

Answer 1

Hello

Thank you for your question and reaching out. I can understand you are having issues related to connecting SQL in VPN.

Please verify that SQL port 1433 is opened Traffic is allowed and not blocked during VPN connection.

Also please Disable any Antivirus program or Windows firewall you may have for temporary purpose.

----------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept as answer--