Installing, Configuring, and Upgrading SQL Server 2000

This course is included in our On-demand training solution.


To describe how to install, configure, and upgrade SQL Server

Target Audience

Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition


Familiarity with a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition, at least one year’s experience administering SQL Server, and at least one year’s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, multiple installations of SQL Server 2000

Expected Duration

125 min.

Course Objectives

Installing, Configuring, and Upgrading SQL Server 2000

  • discuss the hardware requirements and installation options for SQL Server 2000.
  • perform an installation of SQL Server 2000 using the SQL Server setup program.
  • perform a typical installation of SQL Server 2000.
  • locate and describe the directories, tools, and files of SQL Server 2000.
  • start, stop, or pause SQL Server, register servers, create server groups, and connect to SQL Server.
  • install and troubleshoot a SQL Server 2000 installation.
  • upgrade SQL Server 6.5 databases to SQL Server 2000 databases.
  • upgrade from SQL Server 7.0 to SQL Server 2000.
  • upgrade SQL Server 7.0 databases to SQL Server 2000.