Login Falied. The maximun simultaneous user count of 10 licenses for t 1

[Telemaco]

Dear Brains:
I have a W2000 with SQL Server 7.0 Enterprise edition, and an IIS 5.0 with a few pages that look for information in the SQL server. Well a few days ago I had recive this error in the event viewer and in the SQL Server Log:
"18460:
Login Falied. The maximun simultaneous user count of 10 licenses for this "Enterprise Edition" server has been Exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version"
And I don´t know where I have to increase the licences in the SQL server or if I upgrade the version the problem will be solve. This problem couses that when you try to browse the page in internet you recive the same error in your browser that I recive in the event Viewer.
Thanks a lot
Telemaco

 

[greinem]

You set this within the SQL Server Enterprise Manager. Execute this and right-click on the server, go to the properties and click on the Connections tab. At the top you can set the limit for the maximum concurrent user connections (0 = unlimited). Hope this helps.

 

[smsinger3]

Another idea....if your current user connections is already 0, then you should buy more licenses from microsoft, then go into start/control panel/licenses and increase the number.