Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeroen
Starting Member
3 Posts |
 Posted - 2002-04-04 : 07:04:56
|
I do have a slight problem with the SQL Server 7. Sometimes, when I try to execute even a simple query, an error occurs:"Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The maximum simultaneous user count of 10 licenses for this 'Standard Edition' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version."This surprises me, do I have to buy an extra license for every visitor of my site? I tried to run sp_who, it does display that there are about then users active, but they're all using the same login name, they're just visitors of my internet site. Just how can I tell how many people will visit my site at the same time? I checked the maximum number of user connections to my database as well, it's more then 30.000, which should be more then enough.Is there some way to have all visitors handled with only one license? Someone told me that I can configure the maximum number of queries that could be executed at the same time, I just don't know how. Maybe someone can tell me this? If you can, could you tell me if this is a solution, or just leads to another error?Thanks in advance,Jeroen  |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-04-04 : 07:58:29
|
| sql can have limits on connections or users....and you may be getting hit by the wrong one...i know we hit a problem in the very early days of our project, which was resolved by re-configuring our sql to limit by the other option from what was it was.....(but then we have the enterprise edition of SQL, with a large user license limit...which might be a different situation.)others can help more...particularly chadmat...but a search on "licences" or "connection pooling" may yield something useful. |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-04 : 10:33:11
|
| You selected the wrong licensing mode! Sounds like you've deployed 10 client access licenses in "Per Server" mode...For SQL Server 7 you could buy an Internet Connector license from Microsoft, which would allow an unlimited number of internet users to access your database. You can get more details on SQL7 licensing options here:http://www.microsoft.com/sql/howtobuy/70/pricing.aspWith SQL2k you could buy a "Per Processor" license, which offers benefits similar to SQL7's Internet Connector, and covers internal users as well.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested.Edited by - izaltsman on 04/04/2002 10:34:45 |
|
|
|
|
|
|
|
|
Help! licenses error