Re: SharePoint Portal Server 2003 and SQL Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: spacejunk (anonymous_at_discussions.microsoft.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 08:15:39 -0700

Thats not all to be concearned with. In addition to
clustering

1. If you want to easliy use Log Shipping.
2. If you need more than 2GB of RAM.
3. Standard only supports 4 CPUs unless your running NT
4.0 Ent( If you need more than that you need SQL Ent And
at Least 2000 Adv Serv. more than 8, you need Data Center
Server)
4. No "Linked cubes" support in Standard.
5. No "HTTP access to cubes" in Standard.
6. No Distributed Partitioned Views in Standard.
7. No Parallel index creation in Standard.
8. No Parallel scan in Standard.
9. No Parallel DBCC in Standard.
10. No VI SAN support in Standard.
11. No Indexed views in Standard.
12. No ROLAP dimension storage in Standard.
13. No Multi-Language switching in Standard.
>-----Original Message-----
>You only need Enterprise if you are considering
clustering your SQL servers.
>
>Nigel
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>
>"Meim" <anonymous@discussions.microsoft.com> wrote in
message
>news:F40B97D3-5852-4764-9759-
CC6FFC7525B0@microsoft.com...
>> Using Windows Server 2003, Enterprise Edition, I am
installing a new
>> SharePoint Portal Server 2003. My question: Can I
use either SQL Server
>> Standard or do I have to go with the Enterprise
Edition?
>
>
>.
>

Relevant Pages

  • SQL Server 2000-2005 Clustering
    ... If you do clustering, what O/S requirement is there, ... standard or enterprise? ... Do you also need SQL Server Enterprise to do clustering ?. ...
    (microsoft.public.sqlserver.setup)
  • SQL Server 2000-2005 Clustering
    ... >If you do clustering, what O/S requirement is there, ... >standard or enterprise? ... >Do you also need SQL Server Enterprise to do clustering ?. ...
    (microsoft.public.sqlserver.setup)
  • Re: Do I need Enterprise to do clustering?
    ... you go from 2000 Enterprise to 2005 Standard without problems? ... Microsoft SQL Server MVP ... 2000 requires Enterprise Edition for any clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2000-2005 Clustering
    ... Standard and Enterprise Editions of SQL 2005 will support clustering. ...
    (microsoft.public.sqlserver.setup)
  • Re: knowing of operating system has clustering module
    ... If you are asking how to tell if your O/S is "cluster-able" then yes - ... Enterprise 2003 vs Standard is the easiest way ... ... > I would like to check if I have clustering feature on the machine I'm ...
    (microsoft.public.windows.server.clustering)