Re: Windows 2003 Small Business Premium Edition SQL Server limits

From: Henry Craven [SBS-MVP] (IUnknown_at_Dot.Nyet)
Date: 02/17/05


Date: Thu, 17 Feb 2005 16:28:45 +1100

Good one Jay, I was going to post similarly.

As I see it, even on the LAN side if you had Non Domain machines/users
connected to a custom Web App using the SBS SQL Server and either no or
In-built authentication then there would be no limit on the number of
LAN users either.

It's -only- the SBS authentication that otherwise limits the access to
75 CAL holders. The SQL Server itself does not Monitor / regulate
User/device CALs on the connections and if it doesn't it -must be- PP.
( it only comes in 2 flavours )

...but David, I -can- see why MS and MS Marketing wouldn't want to
promote the fact that SBS's SQL Server is a Dual Processor Per Processor
install.
   ;-)

-- 
Henry Craven {SBS-MVP}
CI Information Technology
----------------------------------------------------
Melbourne SBS Users Group
http://groups.yahoo.com/group/melb-SBSusers/
"Jay" <jay@noemail.nospam> wrote in message 
news:765D813B-F1DE-4275-AC4F-4B00F3C07C46@microsoft.com...
> Taking the line below from your reply:
> "...with SBS's SQL it's only unlimited for anonymous access and that 
> for
> authenticated access SBS CALs are needed..."
>
> Is the "authenticated access" Windows Active Directory authentication 
> only?
> What if someone creates a Forms Authentication to expose a web app 
> where
> username and passwords are stored in a file or in a table? What is 
> someone
> uses custom authentication and uses his/her own mechanism to 
> autheticate
> users for a web app? So you are authenticating and authorising those 
> users to
> acces the web app but they are not touching the Windows 
> authentication - is
> that allowed? Or does SBS 2003 does not make a distinction between the
> various authentication modes, i.e. as long as any authentication mode 
> is used
> it's termed under "authentication"?
>
> Thank you for your input,
>
> -- Jay Scale
>
> "David Copeland [MSFT]" wrote:
>
>> Henry,
>>
>> Just wanting to make sure that it's clear that with SQL Per Processor
>> licenses no user/device cals are needed (as you mentioned below).. 
>> whereas
>> with SBS's SQL it's only unlimited for anonymous access and that for
>> authenticated access SBS CALs are needed and are not based on 
>> concurrent
>> usage.
>>
>> Just in case they might have skipped/missed the other line.. and 
>> remembered
>> only the "Per Processor" part.
>>
>> -- 
>>
>> Hope that helps,
>> David Copeland
>> Microsoft Small Business Server Support


Relevant Pages

  • Re: SBS Premium Edition .. what way is SQL licenced
    ... Another thing to note in using your SQL Server as a backend database is the ... concept of Forms-based authentication and Integrated Windows authentication. ... thereby requiring individual CALs to access SQL Server. ... Chad A. Gross - SBS MVP ...
    (microsoft.public.windows.server.sbs)
  • Re: Windows 2003 Small Business Premium Edition SQL Server limits
    ... you still require SBS CALs. ... > The SQL Server is SQL Server std. ... > - If you're accessing the SQL Server via SBServer authentication> your restricted to a maximum of connections as can be covered by your SBS> User/Device CALs ...
    (microsoft.public.windows.server.sbs)
  • Re: Windows 2003 Small Business Premium Edition SQL Server limits
    ... SBS User/Device CALs " ...and that's SBS's limit in SBS Authentication, ... not a CAL limit within SQL Server. ... connections to the SQL server, then isn't that effectively SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL, SBS, and licensing redux
    ... and Un-authenticated user is one not authenticated to the SBS ... You can create your own Web Application Log-on and ASP Security and have ... (Use SQL Server authentication to ... log onto the SQL Server and not Windows Authentication.....and ...
    (microsoft.public.windows.server.sbs)
  • Re: can i use the IIS and Sql server in SBS 2003 for unlimited number of internet users?
    ... can i use the IIS and Sql server in SBS 2003 for unlimited number of ... Any authenticated access to the SBS ... Any authenticated access to the SBS requires a SBS ...
    (microsoft.public.windows.server.sbs)