MS SQL Licensing question

[EKKC]

If the SQL server is installed, and the database is built to authenticate web users.

If I build my app for 10 users to access, do I need 10 CALs? Or only 2? One for the admin and one for the "web server" as a client?

thanks

 

[homercles337]

What advantages to MS SQL server are there to MySQL?

 

[EKKC]

corporate dont use open source progs?

 

[KB]

I am not a CAL expert but I would guess you would need one SQL Server license for the admin and one for the Web Server account.
CALs are required for authenticated users. Your 10 users would never pass their credentials to the SQL Server.

 

[EKKC]

thats what i gathered.

thanks!

 

[alent1234]

For internet access I think you have to buy a special unlimited external connector license

CAL's are for internal users

 

[alent1234]

Originally posted by: homercles337
What advantages to MS SQL server are there to MySQL?

Is MySQL transactional yet?

 

[BoberFett]

I've been out of IT for a while, but unless things have changed again recently, there is no more internet connector license for MSSQL. They dropped that a couple versions ago. CALs do not apply for internet users, if the server is intended to be accessed by internet users you need to purchase a per processor license.

 

[EKKC]

crap, you maybe right boberfett, according to this doc (word document attached)
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

the problem here is "multiplexing", is IIS considered a multiplexing or pooling software? or is my IIS server accessing the SQL only needing a DEVICE CAL?

 

[kamper]

Originally posted by: homercles337
What advantages to MS SQL server are there to MySQL?

Aside from licensing and the fact that it only runs on windows, the question should be what areas is sql server not better in?

 

[BoberFett]

An IIS server would probably be considered multiplexing, yes. It would also be considered multiplexing if it was an internal only intranet site as well. What they don't want is to have 1,000 people all accessing SQL Server through a web interface on a single CAL.

Device licensing would be used if say you had a single terminal at a department used to access the server, even if many people used that terminal. Rather than giving each user their own CAL, a single one would suffice.

All this is really just academic though. If you want to be properly licensed for an internet server, you need a per processor license.