Connecting MSSQL DATABASE VIA L2TP VPN remote access

Hi Fred Boniphace 

The command to capture packet is tcpdump 'host L2TP VPN IPaddress and port 1433, initiate the traffic from the L2TP VPN system and capture the packet.

For Drop packet capture, please refer the article to capture drop packet for port 1433 - https://community.sophos.com/kb/en-us/127111

find the snapshot of captured pakets

Hi Fred Boniphace 

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

Hi Fred Boniphace 

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

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