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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2002-11-21 : 19:00:37
|
| HI there,I got a licensing error from one of my applications which was connecting to a SQL-SERVER 7.0 with 5 CALs (curently 3 web servers connect to this machine). The error:[Microsoft][ODBC SQL Server Driver][SQL Driver] Login failed. The maximum simultaneous user count of 5 licenses for 'Standard Edition' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version.My question is, does Terminal service users take up a SQL license when connecting to the SQL SERVER?Thanks - matt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-21 : 19:23:12
|
| Yes, please refer to the link:[url]http://www.microsoft.com/sql/howtobuy/servercal.asp[/url]If your web server is on the internet, I am pretty sure that you haven't purchased the correct license (unless only 5 connections are allowed to hit the SQL Server from the web boxes). You will need to purchase a per processor license, which gets pretty expensive. I am not an expert on this, so I could be wrong. Does anyone else know? |
 |
|
|
matt_calhoon
Posting Yak Master
235 Posts |
Posted - 2002-11-21 : 19:38:06
|
| I thought the Server CAL allows up to 5 client devices to access the machine? Each CAL allows for multiplexing:http://www.microsoft.com/sql/howtobuy/multiplexing.aspwhich is fine for my scenario:many internet users-->1 Web Server/COM/MTS ---->1 SQL Data Server = 1 CALPlease note: this is the SQL 7.0 licensing system, I believe the Internet Connector license is for SQL 2000, though I could be wrong?? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-11-21 : 19:51:19
|
Matt,I'm pretty sure you read your link wrong. Here's a paste from that page:quote:
Use of such multiplexing, pooling, or related hardware and/or software does not reduce the number of CALs required for SQL Server. Regardless of how many tiers of hardware or software exist between the SQL Server and the client devices that ultimately use its data, services, or functionality, a CAL is required for each distinct input to the multiplexing, pooling, or related software or the hardware front end. Processor licensing will likely be the appropriate licensing option in these situations, due to its simplicity and affordability.
If you are running web servers, you pretty much gotta have Per-Processor License. You can buy the Per Processors license and use it for 7.0 if you like.http://www.microsoft.com/sql/howtobuy/obtain70.asp[EDIT]BTW, your three webserver are probably making several connections to the DB, thus putting you over your limit. Three webservers running MTS/COM+ doesn't mean 3 connections. It usually means a minimum of three connections, one per server. That Connection will probably be pooled, but if you have several users doing things at the same time (which I'm guessing you do since you haev three websservers) more connections will be established, then added to pool when they are finished, and then removed from pool after the pooling timeout. I think my English teacher would be dissappointed in that run-one sentance, but you get the idea :)[/EDIT]Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda>Edited by - michaelp on 11/21/2002 19:55:21 |
|
|
|
matt_calhoon
Posting Yak Master
235 Posts |
Posted - 2002-11-21 : 19:56:31
|
| Yep, read that wrong!Maybe they should of bolded it like you did. Id better check with our hosting provider as to the processor license situation.thanks - matt |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-11-21 : 20:01:46
|
| You are hosting with someone? If you are on a shared server they'd pretty much HAVE to have the $20,000 per processor license. Remember, they need one of those things for each processor in the box. With some shopping, I think you can get them as cheap as 18k each.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
|
|
Terminal Services use SQL CAL?