?
Solved

Quickbooks 2002 slow on Windows 2003 Small Business Server R2

Posted on 2007-10-03
5
Medium Priority
?
684 Views
Last Modified: 2012-08-14
Have QuickBooks 2002 Premium running on 5 workstations sharing the same data file.  Network was peer-to-peer where one of the workstations acted as the server sitting in the corner and that is where the QuickBooks data file resided.  Everything worked great.

Now a Windows 2003 Small Business Server R2 w/ISA Server 2004 has been put in place and all workstations are connected to the domain and have the ISA client installed and configured.  The QuickBooks data file is now on the Server in a shared folder that ALL users have full permission to and are mapped via a drive letter.  QuickBooks is really slow when doing some tasks initially.  For example generating an invoice can take up to 4 minutes to load but looking at the customer list is fast, takes seconds.  After you get through the areas that are slower once they are fast after that until you close QuickBooks and reopen it.

What I have done to try and resolve the speed problem is:

1.        Turned off indexing on the folder holding the QuickBooks data file on the Server.

2.        Symantec Server/Workstation Anti-Virus 10.2 Business Pack on server excluded scanning folder holding the QuickBooks data file.

3.        Symantec Anti-Virus 10.2 client on all workstations excluded scanning folder holding the QuickBooks data file AND the c:\program files\intuit where QuickBooks is installed.

4.        Verified and rebuilt QuickBooks data file.

5.        Server reboot after all changes.

Still have same problems, some QuickBooks tasks are initially very slow.

After more testing it appears if you log into the QuickBooks data file with a QuickBooks login that DOES NOT have ADMIN rights speed is fine for all QuickBooks functions.  ADD an admin user, the access to the QB file slows the other users.  Not sure how and why QuickBooks user rights have anything to do with the Server and simply accessing a data file.

Anybody else experiencing this problem with any version of QuickBooks?

Regards,
Torrey
0
Comment
Question by:Torrey Bates
  • 2
4 Comments
 
LVL 2

Expert Comment

by:wanaylain
ID: 20113964
I have not experienced the problem, but try adding the user QBDataServiceUser as a domain admin and see if that helps.
0
 
LVL 2

Accepted Solution

by:
Torrey Bates earned 0 total points
ID: 20127867
Thanks for the comment.  I tried that a while ago with no luck.  Right now I have one of the workstations sharing a folder that holds the quickbooks files and all the other workstations map to it.  It works perfect, just like it did prior in a peer-to-peer configuration.

At this point this solution is working perfect and I'm going to close this question.

Regards,
Torrey
0
 
LVL 1

Expert Comment

by:modus_operandi
ID: 20157782
Closed, no points refunded.
modus_operandi
Community Support Moderator
0
 
LVL 1

Expert Comment

by:modus_operandi
ID: 20157784
Closed, 0 points refunded.
modus_operandi
Community Support Moderator
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Use this step by step method when setting up QuickBooks Online. They will allow you to explore the various features of the advanced settings available to you.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses
Course of the Month9 days, 12 hours left to enroll

612 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