Link to home
Start Free TrialLog in
Avatar of milani_lucie
milani_lucieFlag for United States of America

asked on

"Connection Timeout" errors on client's machine ...

Hi,

I have installed my C# windows application on client's machine. And my client is getting "Connection Timeout" error. When i check the processes on SQL Server side, there are NO blocking issues and expensive queries.

I want to check the network traffic of this windows application so that i can come to one conclusion whether this is related to network or related to my program. Simply say whether my client is having enough bandwidth or not to communicate with my server.

Are there any tools available to check this ? Even paid ones are also good but we want to give a trial before purchasing it.

Thanks
Avatar of akhalighi
akhalighi
Flag of Canada image

hmm .. is your client coming over Internet or we are talking about LAN here ?
If your application (from client end) talks to your SQL server (on your server) ; first thing to check is the network connectivity between that client to TCP port of your SQL server.
So the question is ; what is the port that your SQL server is listening on ? Have you enabled your SQL to listen on TCP IP at all ?
Avatar of milani_lucie

ASKER

LAN - Application is deployed by using "Click Once" deployment.

Thanks
Somethimes it is working as expected. There are issues when there is heavy traffic or bandwidth is low. May be this gives you an idea - Thanks
hmm... how come you have bandwidth problems in a LAN ? doesn't make sense.
could be a NIC card issue ... make sure windows firewall is disabled in both ends. (server and client)

Is this the only client with this problem ? any other machine reported the same issue ?

Wireshark is a great network capture utility but here I think something else is wrong that needs troubleshooting.

do you have real-time monitoring enabled on SQL server ?
Yes... I have real-time monitoring enabled on SQL server. And found that there are NO blocking issues and CPU time etc...

Thanks
Okay , still need to know this:

- Any other client complaining about the same issue ? I am trying to isolate the root cause ; let's see if it's something in server side or workstation side ...
Yes.. Others have also same problem. - Thanks
Then it's something on the server side . how is resource usages on the server ? e.g. CPU / Memory usages ? do you see CPU staying in 100% ?

another questions here ; do all users get disconnected at the same time ?
do all users get disconnected at the same time ? Yes...Thanks
ASKER CERTIFIED SOLUTION
Avatar of akhalighi
akhalighi
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial