VPS 및 전용 서버(호스팅 컨트롤 센터) 도움말

Installing MSDE on a Windows Virtual Private Server

Warning: The following only applies to Windows® Virtual Private Servers (VPS) not running Windows Server 2008. Windows Server 2008 does not support MSDE.

While the MSDE is pre-installed on the Windows Dedicated Servers by default, it is not pre-installed on our Virtual Private Servers (VPS). However, it is fairly easy to install and configure.

To Install MSDE on Windows Virtual Private Servers (VPS)

  1. Log in to the server using Remote Desktop.
  2. From the Start menu, go to Control Panel > Add Remove Programs.
  3. Select the listing for Parallels Plesk Panel and click Change.
  4. Expand the Database Management section and click X next to either Microsoft SQL Server 2005 Express Edition or Microsoft SQL Server Desktop Engine.
  5. Select Will be installed on local hard drive.
  6. Click Next and then click Install.

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

To Find the Password in MySQL

  1. Log in to Parallels Plesk Panel as "admin" and select Server > Databases.
  2. On the Databases page, select the MySQL tab and fill in the appropriate fields. (localhost:8306, admin, Parallels Plesk Panel 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' (replace 'newpassword' with your database's new password).
  4. Type GO.
  5. Log in to Parallels Plesk Panel and go to Server > Databases > Microsoft SQL Server.
  6. Change the 'sa' password setting.

이 글이 도움되었나요?
피드백을 보내주셔서 감사합니다. 고객 서비스 담당자에게 문의하시려면 지원 전화 번호 또는 위의 채팅 옵션을 이용하시기 바랍니다.
도와드릴 수 있어 기쁩니다! 더 도와 드릴 것이 있나요?
그것 유감스럽습니다. 혼동이 되었던 사항 또는 솔루션이 고객님의 문제를 해결하지 못했던 원인을 알려주세요.