SQL Server on web site

[Toni]

I want to use sql server standard or workgroup for my web site. Site is on
my server. Do I need to buy procesor licence or
Server Plus Device CALs or
Server Plus User CALs

It would be for one or few databses used by web site on 1 web server and I
will connect to this DB from my PC (by management studio or visual studio).

 

[Paul Shapiro]

See Microsoft's website for detailed licensing, but basically you have
choices. If you purchase a processor license (for the number of physical
processors in your webserver- 1 quad-core cpu needs 1 processor license, but
2 single-core cpu's need 2 processor licenses), then any number of people
can legally connect. If you purchase device CALs, then you need 1 license
for each device from which anyone will be connecting to either the sql
server itself, or any website using the sql server. So if 1 person connected
from their desktop, laptop and cell, that's 3 device licenses. Similarly
with user CALs, but it's one for each distinct user instead of each device.
Since the website is authenticating to the sql server for each client
access, every client and every client device consumes a CAL. Usually the
processor license works out less expensive.

You also have the choice of SQL Server Express for free, if you don't need
any of the features that are omitted in that edition.