Installing SQL Server2000 & Service Pack 4

Installation of SQL is divided into 2 parts. First a standard installation and then applying service pack 4.

(A) - Installation of SQL Standard Edition

  1. Run setup.exe you will see the following screen

  2. Select 'Local Computer' and click 'Next'

  3. Select 'Create a new instance for SQL Server, or install Client Tools' and click 'Next'

  4. On 'User Information' type in the details as required in Name and Company and click 'Next'

  5. On 'Software License Agreement', click 'Yes'



    Enter the license key when requested.

  6. On Installation Definition screen, select 'Server and Client Tools' and click 'Next'

  7. On 'Instance Name', select 'Default' and click 'Next'

  8. On 'Setup Type', select 'Typical' and click 'Next'; if required Destination folder can be changed to another location, it is advisable to leave it default.

  9. On 'Services Accounts screen', select 'Use the same account for each service. Auto start SQL Service'.
    and select 'Use the Local System Account' and click 'Next'

  10. Click 'Next' on 'Authentication Mode' screen.

  11. Click 'Next' on 'Start Copying Files' screen.

  12. On 'Choose Licensing Mode' screen, select 'Per Seat for' and type in the number of seats current license ( typically 5 devices). This will vary from customer to customer.

  13. On 'Setup Complete' screen click Finish.

 

(B) - Installation of SQL Service Pack 4

  1. Run each of the 4 executables shown below under Pre-install/SQL2KSP4 directory (Netspan Installation Disk):

    SQL2000.AS-KB884525-SP4-x86-ENU.EXE
    SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
    SQL2000-KB884525-SP4-ia64-ENU.EXE
    SQL2000-KB884525-SP4-x86-ENU.EXE

  2. Install each executables to the default folder listed 'C:\SQL2KSP4' as shown below:

 

  1. After running all four service packs, go to the directory 'C:\SQL2KSP4'and run 'Setup.bat':

  2. A screen will appear as follows, click 'Next'

  3. On Software License Agreement screen click 'Yes'

  4. On Instance Name screen click 'Next'

  5. On Connect to Server screen, select 'The Windows account information I use to log on to my computer with (Windows authentication)' and click 'Next'

  6. On the SA Password Warning screen select 'I do not want a blank password set password' Enter and confirm password, click 'OK'

 

  1. On the SQL Server 2000 Service Pack 4 Setup screen select 'Update Microsoft Search and apply SQL Server 2000 SP4 (required)'and click on 'Continue'

  2. On Error reporting screen, do not select 'Automatically send fatal error reports to Microsoft', leave it blank and click 'OK'

  3. Final screen shall appears 'Start Copying Files', click 'Next'

  4. After copying and installing files on the machine, a Setup screen appears, just click 'OK'

  5. SQL SP4 is now complete. Select 'Yes I want to restart my computer now' and click finish.

  6. After the reboot, the folder created during SQL SP4 setup (C:\SQL2KSP4) can be deleted:

  7. END of Installation