Thread Info
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 4 replies
  • Subscribers 26 subscribers
  • Views 2271 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Connecting MSSQL DATABASE VIA L2TP VPN remote access

Fred Boniphace

We have an issue of L2TP VPN Connctions, the source  devices is hp windows 10 pcs and the destination device is HP server with windows server 2012 r2, the connection established successful, files and folders are accessible, the only issue is i cannot access the MSSQLSERVER based application that called EXACT GLOBE NEXT.

Find the screenshot of the packets that show traffic of destination IP AND SQL PORT 1433



This thread was automatically locked due to age.
Parents Reply Children
  • +1 in reply to Fred Boniphace

    Hi  

    As per the packet capture, there is a certain communication over push packets but then 192.168.1.10 sends the finish packet to the destination IP 10.1.1.100, The traffic for 192.168.1.10 coming in with finish packet from Port 4 goes to bridge interface and sends out to VPN tunnel ppp0 Interface. Did you check by applying/removing NAT on VPN to LAN and LAN to the VPN firewall rule? Did you try to capture drop packets on Port 1433? the article was shared in the previous response. the command would be drop-packet-capture 'port 1433

  • +1 in reply to Keyur

    Hi Guys

    I managed to solve the issue by fixing my windows server DNS error, There was DNS Name resolution error that i didn't notice, i observered the error message when run NSLOOKUP command on cmd.exe