When I try to ping the server from the workstation , it takes about seconds before replies show up I'm afraid that you will need to talk with the vendor and ask if they expose any method to control the timeout, for instance an environment variable. And the first link suggests that users can control the connection timeout, but I am not able to retrieve the document, since the site throws too many cookies at me. The default connection timeout is 15 seconds, so if your network in that bad state that ping takes seconds to respond, you need to increase the connection timeout.
You set the connection timeout in the connection string or in the DSN if you are using one. Sign in. United States English. You may start your troubleshooting from that. And see if there are any policy in your Firewall. Office Office Exchange Server. Not an IT pro? Windows Server TechCenter. Sign in. United States English. Find centralized, trusted content and collaborate around the technologies you use most.
Connect and share knowledge within a single location that is structured and easy to search. Sometimes the statements are not very efficient or are against quite large tables so they take three or four minutes to complete when run from SQL Management Studio. When the statements are sent from the application, the following time-out is reported by it:. It's not possible to immediately improve the SQL statements sent so I need to temporarily increase whatever time-outs are being hit.
But I cannot seem to find a time-out that corresponds to this error message. Then there is the user, very annoying factor ;- this implementation can also time out- loose interest in your site. There are lots of things we DBA's do to fix programmer's errors, the encapsulation method mentioned is only one of many options. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Sign in to vote. I had to reboot the server and after the reboot everything was back to normal. I would request you all to help me to get the root cause of this problem. Wednesday, May 29, AM. Thursday, May 30, AM.
Hi, Concur with Eswar. Regards, Sabrina.
0コメント