"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
milani_lucieAsked:
Who is Participating?
 
akhalighiConnect With a Mentor Commented:
something on the server . CPU or something .
0
 
akhalighiCommented:
hmm .. is your client coming over Internet or we are talking about LAN here ?
0
 
akhalighiCommented:
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 ?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

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

Thanks
0
 
milani_lucieAuthor Commented:
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
0
 
akhalighiCommented:
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 ?
0
 
milani_lucieAuthor Commented:
Yes... I have real-time monitoring enabled on SQL server. And found that there are NO blocking issues and CPU time etc...

Thanks
0
 
akhalighiCommented:
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 ...
0
 
milani_lucieAuthor Commented:
Yes.. Others have also same problem. - Thanks
0
 
akhalighiCommented:
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 ?
0
 
milani_lucieAuthor Commented:
do all users get disconnected at the same time ? Yes...Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.