***************************************************************
    Microsoft SQL Server 2000 Workgroup Edition Readme File
                       October 13, 2004
***************************************************************
(c) Copyright Microsoft Corporation, 2004. All rights reserved.

This file contains information that supplements the Microsoft 
SQL Server 2000 documentation.

***************************************************************
Contents
***************************************************************

1.0 Introduction
  1.1 Hardware Requirements
  1.2 Operating System Requirements
2.0 Installing SQL Server 2000 Workgroup Edition
  2.1 Supported Upgrades
  2.2 Not Included in a Minimum SQL Server Installation
  2.3 Requirements for Active Directory Integration
3.0 Documentation Notes
  3.1 Values Returned by SERVERPROPERTY Function
  3.2 Cross-Database Ownership Chaining
4.0 Notification Services and Reporting Services Support
5.0 OPENXML in SQL Server 2000 Workgroup Edition

***************************************************************
1.0 Introduction
***************************************************************
This file contains important information you should read
before installing Microsoft SQL Server 2000 Workgroup Edition.

SQL Server 2000 Workgroup Edition provides a cost-effective, high-
performance, entry-level database solution for businesses. 
This version can use up to 2 processors and up to 2 gigabytes
(GB) physical memory. This version does not include Analysis
Services, English Query, Notification Services, or Reporting
Services. 

SQL Server 2000 Workgroup Edition includes SQL Server 2000 Service 
Pack 3a (SP3a) and the latest security update for SQL Server, 
MS03-031, as well as an updated version of SQL Server 2000 Books 
Online.

The SQL Server 2000 SP3a Readme and the SQL Server 2000 SP3a 
Readme Addendum (KB Article 816502) provide additional information 
about SQL Server 2000 SP3a.  The documents are available at 
http://go.microsoft.com/fwlink/?LinkId=35425.
 
To access the documents:
1. Select the appropriate language in the Full Download list, 
   and click GO. 
2. On the download page, under Related Resources, click the 
   documents you want to view. 
 

1.1 Hardware Requirements
SQL Server 2000 Workgroup Edition operates on computers 
running Intel or compatible Pentium, Pentium Pro, or Pentium II 
processors. The processor must be running at a minimum of 166
megahertz (MHz).

Memory (RAM) requirements: 64 megabytes (MB) minimum
Hard drive requirements: 95 to 270 MB, 250 MB typical

Monitor with VGA resolution; the SQL Server graphical tools 
require a monitor with 800x600 resolution or higher.

A CD-ROM drive, and a Microsoft Mouse or compatible pointing
device.

1.2 Operating System Requirements
SQL Server 2000 Workgroup Edition requires Internet Explorer 5.0 
or later, and is supported on these operating systems:
Windows 2000 Advanced Server (Service Pack 4 or latest service 
 pack)
Windows 2000 Datacenter Server (Service Pack 4 or latest service 
 pack)
Windows 2000 Professional (Service Pack 4 or latest service pack)
Windows 2000 Server (Service Pack 4 or latest service pack)
Windows XP Professional (Service Pack 2 or latest service pack)
Windows Server 2003, Datacenter Edition (or latest service pack)
Windows Server 2003, Enterprise Edition (or latest service pack)
Windows Server 2003, Standard Edition (or latest service pack)

***************************************************************
2.0 Installing SQL Server 2000 Workgroup Edition
***************************************************************
On the SQL Server 2000 Workgroup Edition CD, use the autorun 
setup program to install the SQL Server 2000 Workgroup Edition 
components. The autorun setup program is executed automatically 
when you insert the CD in the drive. You can also execute it by 
selecting the Autorun.exe program in the root folder of the 
SQL Server 2000 Workgroup Edition CD. 

Remote setup is not available. Instead, use unattended (.iss) 
setup to install SQL Server 2000 Workgroup Edition through 
Terminal Server or Remote Desktop connections.

2.1 Supported Upgrades
Upgrades from SQL Server 2000 Workgroup Edition to SQL Server 
2000 Standard Edition or to SQL Server 2000 Enterprise Edition 
are permitted.  

There is no upgrade path to SQL Server 2000 Workgroup Edition 
from any SQL Server 2000 edition (Personal, Developer, Evaluation, 
MSDE, WMSDE, Standard, or Enterprise). 

Upgrades to SQL Server 2000 Workgroup Edition from any edition 
of SQL Server version 7.0 or earlier are blocked.

2.2 Not Included in a Minimum SQL Server Installation
Full-Text Search is not included in a minimum installation of
SQL Server 2000 Workgroup Edition.

2.3 Requirements for Active Directory Integration
To register an instance of Microsoft SQL Server 2000 Workgroup 
Edition in Active Directory, the instance of SQL Server must be 
installed on a computer running Microsoft Windows 2000 or 
Microsoft Windows Server 2003 with the Active Directory service 
enabled. The SQL Server service must also be configured to run 
under either the Windows LocalSystem account or a Windows domain 
account in the local administrators group. This requirement must 
be met to add databases and publications from the instance to 
Active Directory. Instances of SQL Server 2000 Workgroup Edition 
configured to run under a power user account do not have 
sufficient permissions to invoke all of the SQL Server components 
required to work with Active Directory.

***************************************************************
3.0 Documentation Notes
***************************************************************
3.1 Values Returned by SERVERPROPERTY Function
The Transact-SQL built-in function, SERVERPROPERTY,
returns the following values for the listed properties:
 
  Property       Value
  -------------  --------------
  EngineEdition  2
  Edition        Workgroup Edition
 
Note that the 'EngineEdition' property returns 2 for
both Standard Edition and Workgroup Edition.

3.2 Cross-Database Ownership Chaining
The Cross DB Ownership Chaining configuration option is off by 
default. For more information, see "Cross DB Ownership Chaining" 
in SQL Server Books Online.

***************************************************************
4.0 Notification Services and Reporting Services Support
***************************************************************
Notification Services is not intended to be used with SQL Server 
2000 Workgroup Edition. Microsoft does not support this configuration.

SQL Server 2000 Workgroup Edition cannot be used to host the 
metadata for Report Server. Microsoft does not support this 
configuration.

***************************************************************
5.0 OPENXML in SQL Server 2000 Workgroup Edition
*************************************************************** 
SQL Server 2000 Workgroup Edition is based on SQL Server 2000 SP3a, 
which does not include the MSXML 2.6 component that is required 
by sp_xml_preparedocument and OPENXML. To obtain MSXML, you can 
either download it from 
http://support.microsoft.com/default.aspx?kbid=823490 
or upgrade to SQL Server 2000 Workgroup Edition SP4 after the 
service pack is available.

 