Applying MSDE Service Pack 4 to your MSDE Instance

  1. From the Microsoft website, download, save, run and extract MSDE 2000 SP4 (SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE)
  2. Open a command prompt and navigate to:
    C:\SQL2KSP4\MSDE\
  3. Type the command
    setup /upgradesp sqlrun INSTANCENAME=$INSTANCENAME /L*v c:\msdelog.txt
    This will upgrade the instance. You will then be prompted to reboot.

    NOTE: If you receive a warning message
    Setup has detected that your current SA password is set to blank.
    (It then details what you should do)
    you must change the SA password from blank to a secure password. To do this

    1. Open a command prompt and type the command
      OSQL -U sa -S .\$INSTANCENAME
    2. Press enter, type 
      Password:
    3. Press enter.
    4. At line 1> type
      sp_password @old = null, @new = 'qwerty/1', @loginame ='sa'
    5. Press enter.
    6. At line 2> type go
    7. Press enter then you will see a confirmation message
      Password changed.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: