Use the following as a checklist before you install SQL Server 2000:
- Have your SQL Server 2000 CD, Installation Key, and operating system CD handy
- You should be logged on using an account that has Administrative rights.
- Disable any Antivirus software that is running as it can sometimes effect the installation.
- Shut down any services or applications that depend on SQL Server, Data Source Names (DSN), or Open Database Connectivity (ODBC).
- Close any unnecessary applications that access the registry
- Close the Event Viewer (Microsoft says so!)
Installation Overview
1. When you place the SQL Server 2000 CD-ROM in your drive, you are greeted with the screen shown in the link below. If you don’t see the SQL Server menu, you most likely have autorun disabled. To start the SQL Server menu manually use the Windows Explorer and run autorun.exe from your CD-ROM drive. You can also use “Run…” from the start menu and enter d:\autorun.exe where d: is the letter of your CD-ROM drive.
Click on “SQL Server 2000 Components” to view the available components you can install.
2. Now we are presented with three options on the components screen. Lets continue our installation by installing the Database Server. We will look at the Analysis Service and English Query components in a later article.
Click on “Install Database Server” to begin the SQL Server 2000 Installation.
3. The installation of the Database Server now begins.
Click Next to continue the installation.
4. We are now prompted to select which computer we would like to install SQL Server on. There are three options:
- Local Computer – Installs SQL Server onto the local computer
- Remote Computer – Installs SQL Server onto a remote computer on the network
- Virtual Server – Used for installing SQL Server onto a Server Cluster