Installation of Sql Server 2000

Before starting installation process, we check the computer name:


  Start  - Control Panel - System - Computer Name - Change    


If the text box against Computer Name contains  "Wrong name" or  "(ULTA-SIDHA) name" then correct it to proper name (no space) and   select OK button.


Sql Server 2000 Installation Process :-

                           To install "Sql Server 2000", You have to follow various steps written below. 

Double click on  Autorun  or the  Setup of Sql Server 2000. 

  (While giving name don't give space with Name in between)

1.  Select Sql Server 2000 Components

2. Install Database Server

3. Next 

4. Select - Local Computer Radio Button 

                Then Press Next Button

5. Select - Create a new Instance of Sql Server

                or install client tools Then Press Next Button 

6. On the next screen Enter the name and 

   company name (Default will appear - Don't change.) 

   Then Press Next Button

7. Press Yes Button

8. Select Server and Client tools radio button

    Then Press Next Button

9. Remove Default Checkbox 
    and give instance name (eg. MayurDB)

    Then Press Next Button

10. Select Typical radio Button 

      Then Press Next Button

11. Instead of use a Domain User Account 

     Select Use the local system account radio button

     Then Press Next

12. Instead of Windows Authentication Mode

      Select Mixed Mode Radio Button 

                                                                                            (note: give the password- yours surname)

      Superuser username will be (sa)

      Type /  Retype Password of username

      Then Press Next button

13. Press Next and use common sense for next screens

A Sql Server ICON with Green Triangle will appear on task bar. It means that Sql Server is running. If it doesn't appear then 

Start - All Programs - Microsoft Sql Server - Service Manager

Three Buttons appear (Start / Stop / Pause) Use Common sence

Select the AutoStart Service when OS Starts Check Box Testing:

Start - All Programs - Microsoft Sql Server- Query Analyzer 

Enter login name (sa)

Enter password  (Whatever you specified during installation)

A window will appear where you can type Sql Statements type the following 

Create table student

(roll int, name char(20))

Press (F5) to execute (don't use the concept of; like Sql Plus, that is done in ORACLE)

Then remove the create statement from Query Analyzer window and type the following

Insert into student values (101,'Ram')

Press (F5) the clear it and type (Select * from student) and press (F5) Creating a new Database

1.Start Enterprise manager

2.Expand the Microsoft Sql Servers node

3.Expand the Sql Server Groups node

4.Expand the (Local) node

5.Right click on Database Node

6.Select new Database option

7.Specify the name of the database (eg. shop)

8.Click on OK

Creating a new user account and granting rights for the created database

1. Expand the security node

2. Right click the login node

3. Select new Login option

4. Type the name (eg. Mayur)

5. Select the Sql Server authentication radio button

6. Type the password (eg. Upadhyay)

7. Select the Database combo box given below

    the password text box and select our database (eg. shop)

8. Select Server Roles Tab from top and check all the options

9. Select the Database Access Tab from top and select

    the shop database

10. In the permit in database Role section given below, 

     select all the checkboxes 

11. Click OK

12. Password confirmation will be asked, type your 

     assigned password.

13. Close Enterprise Manager.

Now when you start Query Analyzer and Login by the login created then your default database will be shop and you will have all the rights to it.