8 concurrent connections error 17052 from SQL Server 2000?

A customer's system was (supposedly) upgraded from MSDE to SQL Server 2000 several months ago.  They are just now getting it ready for deployment, and during testing they are getting the same error that we're accustomed to seeing from MSDE about the system being configured for 8 concurrent connections.  Naturally, the guy who did the upgrade no longer works here.  Nobody in our shop can figure out why we'd be getting this message in the event log.  Unless the upgrade just wasn't done right.  I'm looking for ideas about what may have happened and what to do about it.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

open query analyzer,
run the following command


check the results and search for a row with name field 'user connections', see what is the runvalue. if it is 8 you can change it to increase number of user connections by using the following command

sp_configure 'user connections', 10 -- this command increases user connections to 10

if you cannot find a row with name field 'user connections' run the following

sp_configure  'show advanced options', 1

for more info  you can search in books online for sp_configure.
Note that setting user connections value to a high value may degrade the server performance.
this is a note from BOL
If you must use this option, do not set the value too high, because each connection takes approximately 28 kilobytes (KB) of overhead regardless of whether the connection is being used. If you exceed the maximum number of user connections, you receive an error message and are not able to connect until another connection becomes available.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LanMan03Author Commented:
The main limitiation to my understanding is my thorough ignorance of SQL and relasted subjects.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.