Applying MSDE Service Pack 4 to your MSDE Instance

October 19, 2009
  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

Where do I get the installer for MSDE SP4?

June 25, 2009

Microsoft SQL Server Desktop Engine (MSDE) is a free version of Microsoft SQL Server that is suitable for logging data in smaller networks.

(Microsoft does not support installing MSDE on Windows Server 2008).

Language Link
English http://eval.websense.com/auxiliary/MSDESP4/MSDE-en.zip
Brazilian Portuguese http://eval.websense.com/auxiliary/MSDESP4/MSDE-bp.zip
German http://eval.websense.com/auxiliary/MSDESP4/MSDE-de.zip
Spanish http://eval.websense.com/auxiliary/MSDESP4/MSDE-es.zip
French http://eval.websense.com/auxiliary/MSDESP4/MSDE-fr.zip
Italian http://eval.websense.com/auxiliary/MSDESP4/MSDE-it.zip
Japanese http://eval.websense.com/auxiliary/MSDESP4/MSDE-jp.zip
Korean http://eval.websense.com/auxiliary/MSDESP4/MSDE-ko.zip
Simplified Chinese http://eval.websense.com/auxiliary/MSDESP4/MSDE-sc.zip
Traditional Chinese http://eval.websense.com/auxiliary/MSDESP4/MSDE-tc.zip