troubleshooting Question

Replicate MS Access database over sonicwall global VPN client

Avatar of netsmithcentral
netsmithcentralFlag for United States of America asked on
Microsoft AccessVPN
4 Comments1 Solution925 ViewsLast Modified:
I was able to successfully connect a windows 2003 server to another by installing the Sonicwall global vpn client on one server and connecting to my TZ180 router.  It assigns an IP correctly and allows traffic to pass.  At first it was difficult to Drag and Drop files from a network share at \\ipaddress\sharename to the other servers desktop due to "zone warnings".  I added the local IP of the remote server to the trusted zone of IE and that prompt went away.  It appears that file access is normal because I can open files over the VPN or retrieve and copy them.
The problem is that I cannot sync an Access database over the vpn link.  I could do this easily from my previous router.  I have already tried "allow all traffic"  firewall settings in the Sonicwall TZ180 for each public static IP and private static IP of each server machine.  The database tries to replicate, but gets stuck after 1 progress bar unit and will not complete, claiming "disk or network error", like it is losing VPN connection or something.  I can immediately go to Windows Explorer and can browse easily to the replication share location of the database.  Anything with Sonicwalls that would prevent the replication?  

I should also mention that I tried to use Windows based VPN and it had the same effect.  I used RRAS in windows 2003 to connect the client server, and it used to work fine through my previous router.  The RRAS still function sthrough the Sonicwall (enabling VPN pass-through) but the database syncronization is still blocked.  Your help is much appreciated.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros