I have speciality software that is running on a windows 2003 server for small businesses (this was a Dell-ordered clean install system). The software was installed and it uses the Microsoft SQL Desktop Server Engine, so it installed/configured that too. This has been done at about 3-4 other locations and everything has been fine.
However, at this location (4 clients all running the software accessing the SQL Desktop Server on the 2003 Server), the clients are running very slow (about 2-3 times slower than they should).
The connection is apparently still being made because after 10-20 seconds or so the software responds and continues to respond slowly. Data is slowly being loaded into the client programs from the server.
I have tried to troubleshoot it. Thought it might have been some kind of hardware...shut off all but one computer a couple of times. I turned off the cable modem. I replaced the switch connecting the computers. I even brought another switch in and connected only the server and one client on their own 2 node network...still as slow as before. To test the network connection, I downloaded Service Pack 2 network install (~260MB) and transfered it between the two computers (client-->server) and back (server-->client). It took around a minute or less...which is about what it should be...no problem there.
I am at a loss...I've run out of ideas. I figure it must be some problem with the server configuration, specifically the SQL Desktop Server Engine...but I know so little about it that I thought I would ask here for some advice...please help!