Re: SBS 2000 version of SQL2000 - ?limitations

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Milton Sales (MiltonSales_at_discussions.microsoft.com)
Date: 09/26/04 

Date: Sun, 26 Sep 2004 06:49:11 -0700

I have been using SBS2000 for a few years as my server OS. We are about to
move to a software package that runs on SQL. It is supplied with a runtime
SQL MSDE but I am wondering if the version that exists of SQL2000 on SBS2000
is superior to the MSDE version. I have CAL licences for 15 users which I
assume will allow that many SQL log ins simultaneously. What is the database
size? The forum for the software is concerned that microsoft has restricted
the database size of SQL on SBS2000. Is that correct??

"John Bell" wrote:

> Hi
>
> I am not sure why you are wanting to use an older version of SBS? I believe
> it comes with Standard edition with the extra limitation that is can only be
> installed on the SBS server.
>
> If you searched the SBS newsgroup David and Henry seem to know the exact
> details.
>
> http://tinyurl.com/3w9p7
> http://tinyurl.com/6dzy6
>
> John
>
>
> "Milton Sales" <MiltonSales@discussions.microsoft.com> wrote in message
> news:7322D374-F468-432D-B7B7-01A2825705D0@microsoft.com...
> > Are the specs for SQL2000 within SBS 2000 any different from standard SQL
> > 2000? Is the database capacity the same as the MSDE version or standard
> > SQL2000 version with respect to logins and database size??
> >
> > It is not clear in microsofts online information relating to the specifics
> > of the SBS 2000 version.
> >
> > Thank you.
> > --
> > Milton Sales
> > Newcastle
> > Australia
>
>
>

Relevant Pages

  • Re: Redundancy design in SBS Domain
    ... But virtualization was not on my radar, and Exchange and SQL need more with each iteration. ... I originally went the SBS route because it was by far the cheapest was to get a server up and running with SQL Server at the time. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Std - SQL Eval expired...will un-installing break SBS fun
    ... I agree with Claus that you're able to remove SQL 2005 instances if you did ... you can get SBS R2 which already contains SQL Server 2005 ... Workgroup Edition, and upgrade Sharepoint instance, and install other ...
    (microsoft.public.windows.server.sbs)
  • Re: sharepoint error
    ... If you are using SBS 2003 Premium Edition the easiest way is to follow ... to upgrade the SharePoint named instance. ... and search on "Migrating from WMSDE to SQL Server" ... Microsoft Small Business Server Support ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)