maximum number of processes already allocated

Hi all,
Sql server 7.0
our client is getting the below error while accessing the
web application
Maximum number of DBPROCESSes already allocated
when we check the server from our side its working fine.
please let us know is the solution for this.
TIAHi,
Can you please check the "No of user connections" configured in Client's SQL
server.
How to check
From query Analyzer execute the below statement
sp_configure 'user connections'
If the run value is '0' then the allocation is dynamic and problem should be
because of some other issue. Incase if the run value is very low then
increase the value to a higher amount using. Eg to increase it to 100
connections.
sp_configure 'user connections',100
go
reconfigure with override
After this restart the MSSQL server service. If they still have issues
please attach the SQL server error log created during problem situation.
Thanks
Hari
MCDBA
"haseeb" <anonymous@.discussions.microsoft.com> wrote in message
news:a62d01c406e5$0c0e07a0$a301280a@.phx.gbl...
> Hi all,
> Sql server 7.0
> our client is getting the below error while accessing the
> web application
> Maximum number of DBPROCESSes already allocated
> when we check the server from our side its working fine.
> please let us know is the solution for this.
> TIA
>