Retrieving Your MS SQL Database Admin Password
Print this Article
Last Updated:
July 21, 2015 2:21 PM
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 Accessing Your Windows Dedicated Server using Remote Desktop Connection or Accessing Your Virtual Private Server (VPS) Using Remote Desktop Connection for details.
- 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';