QuickBooks does/does not connect
Posted on 2011-03-21
A customer is running QuickBooks premium 2009 on Windows 7 home premium. The application locally works fine. They have 3 other terminals that connect to all 5 databases on the windows 7 home premium “server”. All clients are windows 7 home premium and windows vista home premium. Inside the network everything works well…
They recently installed an ASA 5505 with Cisco any connect VPN, for their out of state offices to connect to the QuickBooks databases for their region (Denver connects to Denver/Cali connects to California).
The VPN works…
They have had issues connecting to the databases through the VPN. Denver can connect to Denver with no problems, but can NOT connect to 3 other databases.
Cali cannot connect to Cali, but can sometimes connect to other databases.
Locally they cannot connect to any databases through the VPN (Public Wi-Fi), but have no problems connecting inside the network. This seems to be sporadic, and with no common variable, other than windows 7 home premium, VPN, and QuickBooks.
I need ideas on how to resolve this debacle… The errors are different every time but the most common is “QuickBooks recognizes the share but cannot recognize the database file as a QuickBooks file”. That same machine connects inside the network with no problems.