MSSQL Workgroup 5 CAL Licence

I do not really understand how MSSQL licensing works so I would like
to be sure to choose the right one. I have one server that is going to
host MSSQL and 2 web servers that will be client of MSSQL. As an
apache web server run multiple instances I do not know if it changes
something in the licensing system. Could you tell me if this
configuration would be ok :
- db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
Win32 with 5-Clients (http://www.provantage.com/microsoft-
a5k-01017~7MCSB0EW.htm)
- 2 * apache web servers accessing to db serveryou will be limited to 5 users connected at the same time. and these will be
only 5 unique named users.
you are in a multiplexing scenario and apache don't change anything here.
if your website is a public site (open to the internet) and you anticipate
thousands of users, then you have to pay for a by CPU license model to
support these users.
1 User CAL CANNOT be shared with multiple users, each user must have a valid
license.
CPU license give you unlimited access. and its only 1 CPU license in your
case (you have only 1 physical CPU)
read this:
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>|||"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
If users outside of your company will be accessing your database server
through the website, then you need a per CPU license.
Note though that per-CPU means per-socket, not per-core, so dual-core CPUs
only need a single license per CPU.|||There are no thousands of clients accessing to MSSQL but two computers
(web servers) accessing to one db server to generate pages. As each
computer (2) will access to MSSQL with the same login for each : is it
considered as 2 clients ? or each apache processus should have is own
CAL ?
Thanks for your help|||no a client is a physical person on the net NOT a intermediate server.
you are in multiplexing mode, the CAL is associated to the user which access
the database through the web site.
so if you have 100 users you need 100 CALs.
so if you are connected to the internet... use the CPU license model where
the number of user is unlimited.
a CAL is NOT a login but controlled through the number of session opened on
the server. so the entire world can use the same login password but this
require 1 CAL by user...
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181716272.288139.109540@.i13g2000prf.googlegroups.com...
> There are no thousands of clients accessing to MSSQL but two computers
> (web servers) accessing to one db server to generate pages. As each
> computer (2) will access to MSSQL with the same login for each : is it
> considered as 2 clients ? or each apache processus should have is own
> CAL ?
> Thanks for your help
>|||On 14 Jun, 03:11, "Jeje" <willg...@.hotmail.com> wrote:
> a CAL is NOT a login but controlled through the number of session opened on
> the server.
No. A CAL is per user or device. The number of sessions opened on the
server is irrelevant.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--