Solved

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

Posted on 2011-03-09
13
800 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
  • 8
  • 5
13 Comments
 
LVL 5

Expert Comment

by:Chris-Vielife
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 5

Expert Comment

by:Chris-Vielife
Comment Utility
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
Comment Utility
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
Comment Utility
Hi,

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

0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 5

Expert Comment

by:Chris-Vielife
Comment Utility
Are both machines currently on the same service pack ?
0
 
LVL 1

Author Comment

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

Accepted Solution

by:
Chris-Vielife earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks
0
 
LVL 1

Author Comment

by:Gilesyit
Comment Utility
Mistake, selected from user
0
 
LVL 5

Expert Comment

by:Chris-Vielife
Comment Utility
I think my advice added to the resolution of the issue.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

This article describes some very basic things about SQL Server filegroups.
SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

10 Experts available now in Live!

Get 1:1 Help Now