Follow these steps to install SQL Server 2000 Desktop Edition, also known as MSDE 2000 Release A.

Download MSDE 2000 - Release A from Microsoft.
Double-click the downloaded package to uncompress it.
Open a DOS command window.
In the DOS command window, go to the directory the package created (cd c:\MSDErelA or similar, by default).
Run this command:
```
setup SAPWD="yoursapassword" SECURITYMODE=SQL INSTANCENAME="YourInstanceName" DISABLENETWORKPROTOCOLS=0
```
If you need to install MSDE to a drive other than C:, add these two parameters to the end of the line of code above:
DATADIR="data_folder_path" Specifies the folder where Setup installs the system databases, error logs, and installation scripts. The value specified for data_folder_path must end with a backslash (). For a default instance, Setup appends MSSQL\ to the value specified. For a named instance, Setup appends MSSQL$InstanceName\, where InstanceName is the value specified with the INSTANCENAME parameter. Setup builds three folders at the specified location: a Data folder, a Log folder, and a Script folder.
TARGETDIR="executable_folder_path" Specifies the folder where Setup installs the MSDE 2000 executable files. The value specified for executable_folder_path must end with a backslash. For a default instance, Setup appends MSSQL\Binn to the value specified. For a named instance, Setup appends MSSQL$InstanceName\Binn, where InstanceName is the value specified with the INSTANCENAME parameter.
When setup completes, you must start the MSDE service. To do so, you can restart the computer. Alternatively, you can go into Control Panel|Adminstrative Tools|Services and start MSSQLSERVER and/or MSSQL$<yourinstancename> and SQLAgent$<yourinstancename>. screenshot: start_services.jpg

To verify that your installation succeeded, go to the DOS command window and try:

osql -S (local)\yourinstancename -U sa -P yoursapassword

then run these commands:

sp_databases
go

Note: When running this OSQL command, you may get an error that the OSQL command is not "valid". If so, close your Command window, re-open it, and try again.

If everything is working, the default MSDE databases should be displayed.

Exit the OSQL utility by typing "exit".

Related