Problems with SQL Server 2000

Tags:
.NET
SQL
SQL Server 2000
In my office we work on SQL Server 2000, and we have software in .NET Question 1: Sometimes the message display reads “You cannot access because of user limit". What does this mean? Question 2: Some of my computers work slow in SQL for an hour or two at a time. What can I do to fix this?
ASKED: March 11, 2010  6:45 PM
UPDATED: March 12, 2010  5:45 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check the server properties to see if a limit has been put on the number of connections.

Check the code to see its using pooling and you have run out of connections in the pool

is this the server or the client that is slow?

If its the servre check with profiler to see if you have any long running queries that are consuming resources. Does it always happen at the same time of day if so check to see what else is happening on the server

———

If you edit the server properties in Management Studio you can set how many CALs you have. If more people that this try to connect it will throw an error. I’m not sure which tab it’s on, but it should be in there somewhere. (At least I know that SQL 7 had this, it might have been removed by the time SQL 2000 was released.) Just set it to the max number possible, or change it to CPU licensing.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following