Close Window x

Frequently Asked Questions

Help Center Search

Installing MSDE on a Windows Virtual Dedicated Server

Print this Article
Last Updated: August 15, 2007 11:04 PM

The following only applies to Windows Virtual Dedicated Servers. While the MSDE is pre-installed on the Windows Dedicated Servers by default, it is not pre-installed on our Virtual Dedicated Servers. However, it is fairly easy to install and configure.

To Install MSDE on Windows Virtual Dedicated Servers

  1. Log in to the server using Remote Desktop.
  2. From the Start menu, go to Control Panel > Add Remove Programs.
  3. Next to Plesk 7.5.5 for Microsoft Windows, click Change.
  4. When the popup window opens, select Modify. A list of all applications that can be modified on the Plesk instance displays.
  5. Click the + next to Database Management.
  6. Select Entire component will be installed on local hard drive for the Microsoft SQL Server Desktop Engine.
  7. Click Next. The MSDE will be installed after a few minutes.

Once installed, the fields on the Databases page under Plesk Server are automatically populated. Note: The password is not the default Plesk password.

To Find the Password in MySQL

  1. Log in to Plesk as Admin and select Server > Databases.
  2. On the Databases page, select the MySQL tab and fill in the appropriate fields. (localhost:8306, admin, Plesk password).
  3. Open the MySQL RootWebAdmin tool.
  4. Browse to and open the file psa.misc.
  5. On the last page, locate the mssql_admin_passwd field to find the MSSQL sa password.

To Find the Password in MSSQL

  1. Log in to the MySQL RootWebAdmin.
  2. In the list of databases on the left, select the psa database.
  3. In the SQL field, located below the phpmyadmin logo in the upper left, type SELECT * FROM `misc` WHERE `param` ='mssql_admin_passwd';. The MSSQL sa password is returned.

To Reset the MSSQL sa Password (without knowing the current password)

  1. In the command line, change the directory to: C:Program FilesMicrosoft SQL Server80ToolsBinn.
  2. Type OSQL -S localhost –E.
  3. Type SP_PASSWORD NULL , 'newpassword','sa'.
  4. Type GO.
  5. Log in to Plesk and go to Server > Databases > Microsoft SQL Server.
  6. Change the 'sa' password setting.