Installing MSDE

If your organization has SQL Server 2000 with SP3a and you do not want to use MSDE, you can proceed to the next section. If you want to install MSDE, do the following:

To install MSDE

  1. Go to Select the appropriate language and download the SQL2KDeskSP3.exe file or the corresponding localized file. (Ultrasound uses the "US English" language envirnoment when connecting to SQL. This environment is installed by default in all localized versions of MSDE and SQL.)
  2. Double-click the file and follow the directions to unpack the installation files.
  3. At the command prompt, navigate to the folder that contains the unpacked files. In that folder, open the MSDE folder.
  4. At the command prompt, run the Setup program by typing the following:
    setup INSTANCENAME=instancename SAPWD=strongpassword DISABLENETWORKPROTOCOLS=0

    For instancename, substitute the desired instance name, such as "frsmon." To ensure database security, choose a strong password to replace strongpassword.

    If you are running the console, controller, and database on the same server, you can omit DISABLENETWORKPROTOCOLS=0. For more information about disabling network protocols for MSDE, see article 814130, "INF: How to Secure Network Connectivity for SQL Server 2000 Local Databases" at

  5. At the command prompt, start the service by typing
    net start mssql$instancename