Solved

QuickBooks does/does not connect

Posted on 2011-03-21
6
538 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:ultreya
  • 3
  • 3
6 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 35186800
Wuindows 7 Home is limited in the number of simultaneous connections allowed. Is it possible that the connection limit is being exceeded?
If so, then the simple solution is to move to a server-class OS, or even Windows XP (which was limited at 20 connections, if memory serves).
0
 

Author Comment

by:ultreya
ID: 35190197
Windows 7 home premium allows for 20 connections as well, If I understood correctly. I do not believe this is the cause, because even after a "server" reboot and no other connections (internal), I still get the hit and miss connections through the VPN.
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 35191057
Hmm.  What about a completely different tack:  Use remote control solutions (LogMeIn, Remote Desktop, PCAnywhere, Terminal Services, etc.) to grant remote access?  This solution provides not only MUCH better performance, but it also provides much better stability, and you are letting only one port through the firewall/VPN.

As for finding out what is really wrong with the current environment, this might be a case where a network analysis tool like Wireshark can be used to monitor the incoming traffic.  However, you'd need it inside the VPN to avoid seeing only encrypted traffic.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:ultreya
ID: 35192168
The RDP setup whas my first suggestion, but for cost reasons they did not want to go that route.

I do not have access to a network analyzer tool. are there any other ideas?
0
 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
ID: 35192202
You can download Wireshark for free from www.wireshark.org.

Without knowing the cause of the problem (which WS can help determine), there is no way to determine a solution.  It's like trying to figure out which part in your car to replace when it doesn't start -- without looking under the hood.
0
 

Author Closing Comment

by:ultreya
ID: 35320651
Turns out according to Intuit.
The bandwidth needs to be a minimum of 32MBs.
Therefore unless the connection through the VPN is at least 32MBs Quickbooks will not work.
Although they can not explain why it works sometimes.
Thanks for the help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Like many others, when I created a Windows 2008 RRAS VPN server, I connected via PPTP, and still do, but there are problems that can arise from solely using PPTP.  One particular problem was that the CFO of the company used a Virgin Broadband Wirele…
OpenVPN is a great open source VPN server that is capable of providing quick and easy VPN access to your network on the cheap.  By default the software is configured to allow open access to your network.  But what if you want to restrict users to on…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now