I’m not sure if this applies to SQL server but there is a chance you can not recover the password. Secure authentication methods should never store the plaintext password. Usually it would go like so:
Register with username and password.
Password is converted to a hash using a one way hashing algorithm.
Hash is stored.
Then when logging in:
Supply username and password.
Password is converted to a hash using the same algorithm.
The new hash is compared against the stored hash
If the stored hash and the new hash are equal then it was an authorised login.
1
solved Sql Server – How to RECOVER (not reset) ‘sa’ password [duplicate]