Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2009-04-14 : 17:16:34
|
| Hi,I have a user that has received the following error several times over the past week. I searched Google and have found extremely little information.Any ideas?EnvironmentWindows 2003 EnterpriseSQL 2005 EnterpriseMicrosoft Great Plains 10***************************A SQL network connection error occurred and your connection was cleared. This probably occurred because all available connections to the server are in use.***************************Regards,Terry |
|
|
barretld
Starting Member
22 Posts |
Posted - 2009-04-20 : 14:49:24
|
| i'm betting that the sql server only allows so many connections at a time. Tell the dba to set the maximum number of connections to unlimited, on the connection tab of the properties of the server within sql server. |
 |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2009-04-20 : 14:58:33
|
| Thanks for the reply. The concurrent connections is set to zero (unlimited).Any other thoughts?Thanks,Terry |
|
|
|
barretld
Starting Member
22 Posts |
Posted - 2009-04-20 : 15:19:41
|
| Maybw the server was just using all connections at the time, meaning some queries are taking forever to run to completion. Use the query governor to limit long running query processing time to 2 hours...this can be found in the same area as before. 2 hours = 7200 |
|
|
|
|
|
|
Network Connection Error