Installing Sql Server 2000

To Install SQL Server 2000 Basic Local Installation.

1.Insert the Microsoft SQL Server 2000 cd in your CD-ROM drive (if the compact disc does not run automatically, double-click Autorun.exe in the root directory of the compact disc), select SQL Server 2000 Components, and then select Install Database Server. Setup prepares the SQL Server Installation Wizard. At the Welcome page, click Next.

2.In the Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the text box. Click Next.


3.In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next. Follow directions on the User Information, Software License Agreement and related pages. In the Installation Definition dialog box, click Server and Client Tools, and then click Next.

4. In the Instance Name dialog box, if the Default check box is available, you can install either the default or a named instance(the default user name is 'sa'). If the Default check box is not available, a default instance has already been installed, and you can install only a named instance. • To install the default instance, click to select the Default check box, and then click Next.

5 To install a named instance, click to clear the Default check box, type a new named instance in the Instance Name box(dont forget this username and password.This will be ther user id and password used to establish connection to the sql server from asp.net page), and then click Next.


6. In the Setup Type dialog box, click Typical or Minimum, and then click Next.

7. In the Service Accounts dialog box, Select Local machine and click next(If you are using sql server to create databases directly on your web domain,then give your user id and password in this step)

8. In the Choose Licensing Mode dialog box, make selections according to your license agreement, and then click Continue to begin the installation. In the Setup Complete dialog box, click Yes, I want to restart my computer now, and then click Finish.