Solved

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

Posted on 2011-03-09
13
804 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
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 5

Expert Comment

by:Chris-Vielife
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:Chris-Vielife
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:
Chris-Vielife earned 500 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:Chris-Vielife
ID: 35084792
I think my advice added to the resolution of the issue.
0

Featured Post

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.

Question has a verified solution.

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

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
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…

791 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