SQL Server 2000 Installation
SQL Server 2000 Installation
SQL Server 2000 is Microsoft's relational database management system. This guide covers a typical installation of SQL Server 2000 on Windows 2000 Server.
Editions
| Edition | Max RAM | Max CPUs | Max DB Size |
|---|---|---|---|
| Personal | 2 GB | 2 | Unlimited |
| Standard | 2 GB | 4 | Unlimited |
| Enterprise | 64 GB | 32 | Unlimited |
| Developer | 64 GB | 32 | Unlimited (dev only) |
| MSDE | 2 GB | 2 | 2 GB |
Installation Steps
- Insert the SQL Server 2000 CD. Setup starts automatically.
- Select SQL Server 2000 Components → Install Database Server.
- Choose Local Computer and click Next.
- Select Create a new instance of SQL Server.
- Enter your name and company. Enter the product key.
- Accept the license agreement.
- Choose Server and Client Tools (typical) or Custom for specific components.
- Select the instance name. The default instance uses
MSSQLSERVER; named instances useSERVERNAME\INSTANCENAME. - Configure service accounts:
- Use a domain account for both SQL Server and SQL Agent services in production
- Grant the account "Log on as a service" rights
- Choose authentication mode:
- Windows Authentication Mode: Uses AD accounts only (recommended)
- Mixed Mode: Allows both Windows and SQL Server logins. Set a strong
sapassword.
- Choose collation settings. The default (
SQL_Latin1_General_CP1_CI_AS) is case-insensitive, accent-sensitive. - Click Next to begin installation.
Post-Installation
- Install SQL Server 2000 SP4 (the final service pack)
- Configure max memory in Server Properties to prevent SQL from consuming all RAM
- Set up regular backups with SQL Agent jobs
- Enable TCP/IP protocol in Server Network Utility if clients connect over the network