Installing MSDE on a Windows Virtual Dedicated Server
Print this Article
Comment on 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
- Log in to the server using Remote Desktop.
- From the Start menu, go to Control Panel > Add Remove Programs.
- Next to Plesk 7.5.5 for Microsoft Windows, click Change.
- When the popup window opens, select Modify. A list of all applications that can be modified on the Plesk instance displays.
- Click the + next to Database Management.
- Select Entire component will be installed on local hard drive for the Microsoft SQL Server Desktop Engine.
- 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
- Log in to Plesk as Admin and select Server > Databases.
- On the Databases page, select the MySQL tab and fill in the appropriate fields. (localhost:8306, admin, Plesk password).
- Open the MySQL RootWebAdmin tool.
- Browse to and open the file psa.misc.
- On the last page, locate the mssql_admin_passwd field to find the MSSQL sa password.
To Find the Password in MSSQL
- Log in to the MySQL RootWebAdmin.
- In the list of databases on the left, select the psa database.
- 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)
- In the command line, change the directory to: C:Program FilesMicrosoft SQL Server80ToolsBinn.
- Type OSQL -S localhost –E.
- Type SP_PASSWORD NULL , 'newpassword','sa'.
- Type GO.
- Log in to Plesk and go to Server > Databases > Microsoft SQL Server.
- Change the 'sa' password setting.