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:
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".