Retrieving Your MS SQL Database Admin Password
Some of the information in this article is advanced material we make available as a courtesy. Please be advised that you are responsible for properly following the procedures below. Customer Support cannot assist with these topics.
Note: This password was randomly created by Parallels Plesk Panel during configuration.
To retrieve your MSSQL database administrator password
- Log in to your Windows server using Remote Desktop Connection. see Connect via Remote Desktop (RDC) to your Windows server.
- From the Start menu, click Run....
- Type
cmd
and press Enter. - Type the following, where "p" is your Parallels Plesk Panel password, and then press Enter:
mssql -u admin -p
- Type your Parallels Plesk Panel password and press Enter.
- Type the following, and then press Enter:
use psa;
- Type the following, and then press Enter:
Select * from misc where param = 'mssql_admin_login' OR param ='mssql_admin_passwd';