Cant connect to sql server over openvpn

Getby

Hello guys, I have an issue related with connection to SQL server using SSMS and hostname\instance while connected to OpenVPN. So what I have done till now is using TCP/IP protocol - with static and dynamic ipall and sql browser. I use pfsense and the build in Openvpn server, I setup the appropriated local networks so the subnet on which is the sql server to be able to get accessed over vpn. I can connect using ip/instance while on openvpn, but i need to make it work with hostname/instance, while connected to local network hostname/instance works with both Named pipes and TCP/IP protocol. P.S additional info on the host where slq server is the firewall is disabled, I don't have AD therefore no nameresolve. Any help will be appreciated. I am not use if its openvpn config issue or the sql or the fact there is no AD and thus no resolve.

mitripoknu

Hi buddy, Did you try checking if the server is blacklisted or not? As that happens at times. Many uses and thus sometime some server are blocklisted so try with other server that might help. Regards, Smith

mitripoknu

mitripoknu wrote Hi buddy, Did you Kodi try checking if the server is blacklisted ShowBox or not? As that happens at times. Many uses and ]Tutuapp[/color] thus sometime some server are blocklisted so try with other server that might help. Regards, Smith

Now working for me after clearing the cache server and re-launching.