Cant connect to sql server over openvpn
Moderators: TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech
-
- OpenVpn Newbie
- Posts: 4
- Joined: Wed Nov 11, 2015 10:20 pm
Cant connect to sql server over openvpn
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.