Does your install fail?
First off launch the CD and run the Environment Check. This will tell you if your going to have trouble.
Here's how to fix it.
Download Microsoft SQL Server 2000 SP4 here
Open command prompt and type osql -U sa, hit enter when prompted for password.
I was prompted with "[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect())."
That means I need to define an instance. New command: osql -U sa -S server\BKUPEXEC
Next message I got was "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
That means i'm running in Windows Authentication only mode. New command: osql -E -S server\BKUPEXEC
I finally got logged in. Now to change the password type the following:
1> sp_password @old = null, @new = 'complexpwd', @loginame ='sa'
Obviously change complexpwd to a password you want.
MSDE needs to be run from a command line. Navigate to the folder where it was extracted
and run setup SAPWD="complexpassword" and hit enter. This should upgrade all your instances.
Setup.exe /upgradesp SQLRUN INSTANCENAME=BKUPEXEC
osql -E -S DC\BKUPEXEC -Q "USE master SELECT @@version" -p
Never did get this working... anyone have any suggestions?