Close Window x

Frequently Asked Questions

Help Center Search

Retrieving Your MSSQL Database Admin Password

Print this Article
Comment on this Article
Last Updated: December 1, 2008 8:41 AM

NOTE: This password was randomly created by Plesk during configuration.

To retrieve your MSSQL database administrator password

  1. Log in to your Windows server using Remote Desktop Connection. See Accessing Your Windows Dedicated Server using Remote Desktop Connection or Accessing Your Virtual Dedicated Server Using Remote Desktop Connection for details.
  2. From the Start menu, click Run....
  3. Type cmd and press Enter.
  4. Type the following, where "p" is your Plesk password, and then press Enter:
    mssql -u admin -p
  5. Type your Plesk password and press Enter.
  6. Type the following, and then press Enter:
    use psa;
  7. Type the following, and then press Enter:
    Select * from misc where param = 'mssql_admin_login' OR param ='mssql_admin_passwd';