MSSQL password location

[blargman]

I'm trying to restore a plesk backup because the psadb is gone. Because someone removed MSSQL from the machine!. I've reinstalled MSSQL since, and I'm now trying to perform the Restore, but I'm receiving an error the password for admin is wrong when I run restore.exe. I don't know what it would have been set at, and I've tried a few things. How can I see or change the password Plesk has setup for MSSQL (psadb)

<when plesk is mostly broke, ie, the website won't come up obviously>.

 

[avsokolov]

Do you remember you old plesk admin password? Try to change the current one to the old using "plesksrvclient -set" Plesk utility. Also send the full error output. It is not quite clear, password for Plesk cp is wrong or database password.

 

[DmitryT]

Please try to reset admin password in MSSQL. Basic steps are described in SWSoft Knowledge Base (but for 'sa' user):

http://kb.swsoft.com/en/870

So, you shoud use 'admin' instead of 'sa'. If user admin does not exist, you shoud create it first and grant privileges to psa database:

> osql -E
1> sp_addlogin 'admin', 'ADMIN_PASS'
2> GRANT ALL ON psa TO admin

Note, that ADMIN_PASS is the Plesk administrator account that can be got from:

> %plesk_bin%\plesksrvclient.exe -get

Hope this helps.

 

[blargman]

this thread is mostly academic at this point as I just reinstalled plesk. I think you guys might have misunderstood my question though. I'm not trying to reset the password, and I have no clue what the old one was. I'm trying to perform a restore, there currently is no psadb. I want to know what Plesk has stored for the password. Obviously it must keep it somewhere, so that 'it' knows what to use when it needs to. Perhaps it's hashed and unretrievable?