Re: SBS Premium Edition .. what way is SQL licenced

Since the SQL Server in SBS uses a per server mode, using it as a backend
database for any public website should not be an issue. In the enterprise
versions, they call it a per-processor license. This means that even an
infinite number of users coming from the Internet do not need any CALs to
access the backend database.

Another thing to note in using your SQL Server as a backend database is the
authentication mode your application will use. In ASP.NET, there is the
concept of Forms-based authentication and Integrated Windows authentication.
In Forms-based authentication, you only use a single account to connect from
your web application to SQL Server. But this also means you will need to
manage user access - login and passwords your application will use to
authenticate users. You can also use Integrated Windows authentication where
IIS will take care of the authentication mode for your application. In this
case, you will be using your own account to connect to the application and
the backend database, thereby requiring individual CALs to access SQL Server.
Understanding how the application works will help you decide on licensing
and CALs purchasing as well
--
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God has plan for
them"


"Rory Niland" wrote:

great.

I've placed a reservation on the mac address for each of the 600 PC's in
another domain and they all have static IP addresses now. They are behind the
same firewall but have access to the public website.

They access the "public" website but I can identify them via IP address in
the browser. They still do not authenticate.

Everything still ok Chad?

"Chad A. Gross [SBS-MVP]" wrote:

Yep, no problem with that. Take a look at awstats
(http://awstats.sourceforge.net/)

--

Chad A. Gross - SBS MVP
SBS ROCKS!
www.msmvps.com/blogs/cgross

"Rory Niland" <RoryNiland@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61B1954F-4AD3-4768-AA6A-796EB717A5E0@xxxxxxxxxxxxxxxx
Ok thats great. Thank you.

If I'm using no authentication and anonymous access is enabled,can I use
the
IP subnet ( from the browser details ) to acertain the general location of
my
hits ( kinda like webtrends but not ) am I violating licence ?

thanks for this


"Chad A. Gross [SBS-MVP]" wrote:

:^)

Anonymous access and multi-plexing are two different topics . . .
multiplexing is never an option for negating SQL CALs for per-server
licensing.

From
http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/bizsolutions.mspx :

Q. I want to use the SQL Server component of SBS 2003 R2 Premium Edition
for
Web-based business applications. Do I need to buy licenses for all those
Internet users?

A. No. As long as the Internet users do not authenticate on the SBS 2003
R2
network, you do not need an SBS 2003 R2 CAL for those users. You also do
not
need to purchase any SQL Server CALs for un-authenticated users. But if
they
authenticate on the network, such as logging in to check on order status
in
a line-of-business application, you will need an SBS 2003 R2 Premium
Edition
CAL.

The key here is anonymous access . . . if you have SQL back-ending a
public web site (e.g. SharePoint), and that site was configured to allow
anonymous access - you can do that, regardless of how many people hit
that
site. The minute users start authenticating to get to that site, then
the
CAL requirements kick in. It's important to realize that
"authenticating"
isn't just restricted to authenticating against AD - any mechanism that
processes a log in to the site (even against a database using forms-based
authentication) is considred authenticating and thus requires a CAL.

--

Chad A. Gross - SBS MVP
SBS ROCKS!
www.msmvps.com/blogs/cgross

"Rory Niland" <RoryNiland@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B38CA833-EC3C-4FE8-A5A4-E190847C1ACB@xxxxxxxxxxxxxxxx

"You are allowed to use SQL on SBS to backend a public website without
needing additional CALs as long as visitors have anonymous access to
that
site. If visitors log in to the site in any way, then SBS CALs are
required." "

Very interesting .. do you have a URL that backs this up ? it seems to
controvene this :

"Sometimes organizations develop network scenarios that use various
forms
of
hardware and/or software that reduce the number of devices or users
that
directly access or use the software on a particular server, often
called
"multiplexing" or "pooling" hardware or software. Use of such
multiplexing
or
pooling hardware and/or software does not reduce the number of client
access
licenses (CALs) required to access or use SQL Server software. A CAL is
required for each distinct device or user to the multiplexing or
pooling
software or hardware front end. This remains true no matter how many
tiers
of
hardware or software exist between the server running SQL Server and
the
client devices that ultimately use its data, services, or
functionality."

taken from http://www.microsoft.com/sql/howtobuy/multiplexing.mspx






.

Relevant Pages

  • Re: SBS 2003 as web server
    ... tell me basically that ANY authentication requires a CAL. ... You're right, Anonymous connections are "free". ... the AD required CALs. ... A senior member of the SBS product group recently ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 standard and SQL Server
    ... you want to install SBS Standard on one machine and then install SQL Server Workgroup on another machine running Windows Server 2003. ... You want to buy CALs for SBS 2003 and use the same CALs to access SQL Server Workgroup. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 as web server
    ... (external users who are not covered by internal use CALs) ... It does not matter what mechanism is used for authentication ... SBS 'user' CALs. ... I am trying to get some clarification on web server licensing before I ...
    (microsoft.public.windows.server.sbs)
  • Re: CAL Complexity -- Whats right here?
    ... So it appears that if *any* type of authentication is required, ... Les Connor [SBS Community Member - SBS MVP] ... > solely within the web site. ... >> How many/what type of CALs do I need? ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 as web server
    ... the AD required CALs. ... Many of the SBS MVP's will be meeting with the product group in a few ... Active Directory Authentication. ...
    (microsoft.public.windows.server.sbs)