Discussion Locked

Network Connections Problem

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a NT 4.0 SP6a Member server that runs SQL7.0. About halfway throught the day anyone who tries to access the server in any way will get an error "No more network connections available". If one or more currently connected users logout then another can attach. I have been the the MS knowledgebase and have had no luck. It is not a licensing issue. I believe that the database application being used with SQL is keeping connections open. If I reboot the server the problem goes away for a few hours. The max connections I get when the problem starts is 10 workstations. The problem also seems to be getting more severe every week. has anyone seen this behavior and know how to correct it?

3 replies

by admin-stuart

First thing that comes to mind is that NT Workstation will allow a max of 10 simultaneous connections. Are you sure your "member server" is not actually running NT Workstation as an OS instead of NT Server? Sorry if this is too obvious or presumptuous, if you hadn't mentioned the 10 connection limit, I wouldn't have mentioned this at all. Good luck.

by oskiller

Check to see the number of user connections that is setup in the SQL configuration. In 6.5 I think the default was 10, but I don't know what the default in 7.0 is. You should be able to access this from the Enterprise Manager, and right click on theserver and select configure. Note that the more connections you setup, the more memory it will use (6.5 allocates 37K to each connection). Increase this to what you think you need, stop and restart SQL and you should be good to go.

This discussion is closed to new replies.