Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

CCH Database takes a very long time to login from Windows Server 2003

Posted on 2011-03-09
13
Medium Priority
?
829 Views
Last Modified: 2012-05-11
Hi There,

I have a problem with my CCH Central database on Windows Server 2003 Small Business Edition Server.

All of the local machines (laptops and desktops) are running Windows XP Pro.

We have recently ordered 7 new laptops (which are exactly the same as the other laptops we ordered a while back) (Compaq 615).

From the 7 new laptops, 4 are currently being used and each employee has told me that it takes a considerable amount of time(10mins+) just to log into the CCH Central database. However, the laptops previously purchased are all able to access this database without any problems and in around 10 seconds.

I am not so familiar with the CCH side of things, so please ask me for additional information if need be.

Thanks in advance.



0
Comment
Question by:Gilesyit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
LVL 5

Expert Comment

by:Christopher White
ID: 35081645
Hi

I do not know much about CCH and the way it presents the database.

What I would look at is how it is being severed to your network.

Does CCH have a service that the clients connect to on a specific port ?
or does CCH use SQL to manage the database?
or does CCH have a data file shared by a network share ?

I would try rule out network or connectivity limits/bottle necks. I would want to try a login with the new notebook before the rest of the accounting staff login. If it is still running slow. I would focus on the notebook.

Do you wipe the new notebook and install your own image?
 -if not try running it in safe mode with networking. So that you can rule out any vendor added   software on the notebooks which may be causing the issue.    

-if you do are you using ghost walker or NewSID ?

0
 
LVL 1

Author Comment

by:Gilesyit
ID: 35081850
Chris,

Yes, it seems to be with the new notebooks themselves,

The staff can quite happily login to the CCH database on an older laptop or desktop but as soon as anyone (i have tried many user accounts) tries to log on with new laptops, it just freezes for a good 10 minute

The 7 new laptops came pre-installed with Windows 7 and as CCH is apparently only compatible with XP, I had to wipe them and install XP.

We use no such programs called ghost walker of NewSID.

Il try running the laptop in safe mode and let you know what happens.
0
 
LVL 1

Author Comment

by:Gilesyit
ID: 35081990
Chris-Vielife,

I have just run the laptop in safe mode.

I got two staff members to enter their login details in (including mine) and it is running very fast, just like the other machines.

You don't think it could be to do with a service running such as BITS that could halt or cause high latency on that connection to the database do you?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 5

Expert Comment

by:Christopher White
ID: 35082053
Hi

Could be, as I do not know the full detail of how CCH connects to its data. This sounds like you may need to compare what is running on a "Working machine" and one of the new ones.

I would have them both open up next to one another and go "start" >run > msconfig  and compare the running services / startup lists see what is different.

Something that I like to check as well which might be remotely related to your issue is making sure that your network cards on the new notebooks are set to Full Duplex instead of auto.

Let me know  
0
 
LVL 1

Author Comment

by:Gilesyit
ID: 35082119
Hi

I'm not too sure how CCH is connected to the server apart from that to run it on the local machines, a MS-DOS Batch file is executed from a mapped drive on the server and the shortcut link to the CCH central database that resides on the local desktop to access the database is targeted towards an exe on the server drives, which is the same path for both new and old machines.

Yes, I have two laptops running concurrently next to each other on my desk as we speak. I have already looked through services.msc and msconfig and the only service that seemed to be different in terms of running was that BITS service which after running on the problematic laptop, the problem still persists.

I will take a look at the NIC card's settings and get back to you shortly

Thanks

0
 
LVL 1

Author Comment

by:Gilesyit
ID: 35082255
Hi,

I have changed the network card to 100Mbps Full-duplex and no change to the speed of login to CCH database.

0
 
LVL 5

Expert Comment

by:Christopher White
ID: 35082261
Are both machines currently on the same service pack ?
0
 
LVL 1

Author Comment

by:Gilesyit
ID: 35082269
Yes they are, and all recent updates have been done on both
0
 
LVL 5

Accepted Solution

by:
Christopher White earned 2000 total points
ID: 35082730
Since it works in safe mode, and safe mode uses the bare minimum of driver and services to start up. I would try an experiment.

On the new machine run msconfig and disable all none Microsoft services (hide all ms services > Disable all) and disable all items on startup list. Reboot and see it has the desired effect.

Let me know.

 

0
 
LVL 1

Author Comment

by:Gilesyit
ID: 35084616
Sorry for the late reply, I got called out

I carried out the following things which you kindly mentioned above.

From turning off all the non-related MS services, CCH was logging in at normal speeds. From this I narrowed the problem down to be with the stupid E-Trust Anti virus/Pest control program which we have had loads of problems with. It had done an update on all of the new machines which from a process of elimination on the settings, it was to do with the REAL-TIME  protection of all network drives, which I'm guessing has caused it to be constantly querying the request against the database. I simply unchecked the box and wolaaa it worked.

Thanks a bunch for your time and knowledge on this matter Chris
0
 
LVL 1

Author Comment

by:Gilesyit
ID: 35084653
Thanks
0
 
LVL 1

Author Comment

by:Gilesyit
ID: 35084753
Mistake, selected from user
0
 
LVL 5

Expert Comment

by:Christopher White
ID: 35084792
I think my advice added to the resolution of the issue.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

618 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