Re: Windows 2003 Small Business Premium Edition SQL Server limits

From: David Copeland [MSFT] (davidcop_at_online.microsoft.com)
Date: 02/16/05


Date: Wed, 16 Feb 2005 15:49:01 -0600

Henry,

I would exactly say its "effectively "Per Processor"" since the back ending
only applies if the usage is via anonymous access. For authenticated
access, you still require SBS CALs.

http://www.microsoft.com/WindowsServer2003/sbs/techinfo/overview/licensingfaq.mspx

      Q. Can I use the SQL Server component for Web-based business
applications?

      A. Yes, new with Windows Small Business Server 2003 is the ability for
you to use the SQL Server component for an unlimited number of
un-authenticated users. As long as you are un-authenticated, you also do not
need a Windows Small Business Server 2003 CAL.

Also, might want to look at the SBS EULA regarding it not being able to be
used for commercial hosting..

-- 
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Newsgroups:
SBS v4.x : microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Henry Craven [SBS-MVP]" <IUnknown@Dot.Nyet> wrote in message 
news:%2350JA0FFFHA.2032@tk2msftngp13.phx.gbl...
> The SQL Server is SQL Server std. so pretty much the same limitations 
> apply but with a couple of bonuses.
>
>    -    As SQL server std you get a Terrabyte of Data Storage.
>
>    -    Because in SBS 2003 MS removed the restriction on Back-ending 
> public Websites with the SQL Server it's effectively "Per Processor"
>
>    -    Because SBS 2003 Supports 2 Physical ( 4 Hyperthreaded ) CPUs it's 
> effectively a 2 CPU License
>
>    -    MS have allowed Unlimited SQL Server Instances on SBS 2003.
>
>    -    Because it's SBS you -cannot- install the SQL Server(s) on other 
> than the SBServer Server.
>
>    -    It's Still SQL Server Std so will only use 2 GB RAM. ( Even though 
> SBS itself allows 4Gb )
>
>    -    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
>
> That's about it.
>
> -- 
> Henry Craven {SBS-MVP}
> CI Information Technology
> ----------------------------------------------------
> Melbourne SBS Users Group
> http://groups.yahoo.com/group/melb-SBSusers/
>
> "SARPER SARIDAL" <sarper@saridal.com> wrote in message 
> news:erWL3lFFFHA.4004@tk2msftngp13.phx.gbl...
>> What are the limits of SQL server in Windows 2003 Small Business Server 
>> Premium Edition.?
>>
>> Maximum number of connections? Licensing? Maximum database size? and so 
>> on...
>>
>> Urgent please reply.
>>
>> Thank you.
>
> 


Relevant Pages

  • 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 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint URL error
    ... When we rename the file in Web UI/Explorer view, Sharepoint object model ... So we should focus on SQL server. ... Please create one new WSS site at the SBS server, ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS Backup problems
    ... search for *SQL* there a Microsoft SQL Server folder located under C:\Program ... > From the backup log, I find the following error message. ... > - You back up data from a volume that contains a Microsoft SQL Server ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS Premium Edition .. what way is SQL licenced
    ... Chad A. Gross - SBS MVP ... >> need to purchase any SQL Server CALs for un-authenticated users. ... The minute users start authenticating to get to that site, ...
    (microsoft.public.windows.server.sbs)