Unzip the file which contains an EXE - Save this file to your desktop Run the EXE and allow the Service Pack installation files to be saved into the default folder i.e. C:\SQL2KSP4 Go to a Command Prompt i.e. Start >> Run >> CMD
Type in : cd C:\SQL2KSP4\MSDE
Next type in one of the following at the command prompt depending on the install required. Obviously replace saPassword with the correct sa password for MSDE you are upgrading :
For a default instance that uses Windows Authentication and has its network protocols disabled, execute:
setup /upgradesp sqlrun /L*v C:\MSDELog.log
For a default instance that uses Windows Authentication and has its network protocols enabled, execute:
setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*v C:\MSDELog.log
For a named instance that uses Windows Authentication and has its network protocols disabled, execute:
setup /upgradesp sqlrun INSTANCENAME=InstanceName /L*v C:\MSDELog.log
For a default instance that uses Mixed Mode Authentication and has its network protocols disabled execute:
setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa
UPGRADEPWD=saPassword /L*v C:\MSDELog.log
For a named instance that uses Mixed Mode Authentication and has its network protocols disabled execute:
setup /upgradesp sqlrun INSTANCENAME= InstanceName SECURITYMODE=SQL
UPGRADEUSER=sa UPGRADEPWD=saPassword /L*v C:\MSDELog.log
Line breaks were included in these examples for readability. Commands must be executed without line breaks.
Normally for an upgrade you will use the Mixed Mode Default Instance upgrade command which is
setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa
UPGRADEPWD=saPassword /L*v C:\MSDELog.log
Original Microsoft Links (if above links do not work)
