May 29, 2002 at 3:57 pm
I am a small companie's programmer and DBA. We run SQL Server 6.5 on its own Dell server and use VB for our apps.
The last couple days I've started having problems. My VB programs error out, telling me that:
"Unable to connect. The maximum number of '350' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure"
When I move to Enterprise Manager and look at current activity I never see more than about 50 connections. Usually most of those are idle and 1 or 2 are active at a time.
I don't think that the apps are a problem as they have not changed recently. But I have not made any big changes on the database either.
Any help would be greatly appreciated.
thanks,
Ron
He is no fool who gives up what he cannot keep in order to gain that which he cannot lose.
He is no fool who gives up what he cannot keep in order to gain that which he cannot lose.
May 29, 2002 at 9:18 pm
run sp_configure and up the number of connections. Also, check sp_who for an accurate count of users.
Steve Jones
May 30, 2002 at 10:16 am
I did use sp_who and the number of connections that I was seeing were correct.
I kept hammering away at this yesterday and I believe I found the problem. The data device that the database was on was full. I used disk resize to make the device larger and then I expanded the database. I am hoping this takes care of the problem but also leaves me w/a new question.
If I delete data from the database will it get smaller as I delete or do I need to go to edit database and use the shrink option?
Thanks for the suggestions.
He is no fool who gives up what he cannot keep in order to gain that which he cannot lose.
He is no fool who gives up what he cannot keep in order to gain that which he cannot lose.
May 30, 2002 at 10:33 am
I believe you can free the space in a 6.5 device but not actually shrink the device. The only way to change is export the data, dump the device and build a new device, then reimport the data.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 30, 2002 at 3:02 pm
What a strange thing. (just to update in case anyone else looks at this thread).
My problem seems to be related to the machine running the programs. I can run the same programs w/no problems somewhere else. But when I try to run it from that machine I use up the connections and other people accessing the database starting getting errors that the limit has been exceeded (though as far as I can tell it never really gets there)
I'm not sure what the real problem is here but for now my workaround is to not run those programs on that machine.
He is no fool who gives up what he cannot keep in order to gain that which he cannot lose.
He is no fool who gives up what he cannot keep in order to gain that which he cannot lose.
May 30, 2002 at 3:33 pm
Could be the MDAC components on that machine are an issue.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 30, 2002 at 6:21 pm
I don't know- I am going to take a hard look at it next week. I doubt it is MDAC because it is my main development machine and is pretty up to date.
I'm wondering if it is a network thing. I'm not sure but I appreciate the suggestions.
He is no fool who gives up what he cannot keep in order to gain that which he cannot lose.
He is no fool who gives up what he cannot keep in order to gain that which he cannot lose.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply