Unanswered: error 500 maximum concurent users have reached
We have three Windows 2000 web servers in a WLBS environment accessing a DB server. Though we have only 180,140 and 40 connections respectively on the servers we received ERROR 500 - maximum concurent users have reached.
You may have only 300 users on the website, but the web pages themselves could be opening hordes of connections. Two things to check would be the license for SQL Server (in control panel should be a license applet for SQL Server). Check to see if you have entered 500 CALs. If you have set the server up as per-processor license, or if you have plenty of cals entered on the system, you can check in Enterprise manager to see how many connections are allowed. Right click on the server, then properties, then the connections tab. Make sure the max connections is set to 0 (unlimited). 0 is the default, and I have not had any problems with it, so far. Hope this helps.
Hmm. After reviewing the post, I seem to have mistaken the error number for a parameter. Looks like my suggestion may not help after all. Are you certain this is a DB error, and not a web error? Check the SQL Error log to be sure.