May 31, 2016 at 3:35 am
Any ways to generate SQL logins with passwords ...
Revlogin and other scripts will give the password but that will be encrypted .. I am looking for the actual password and not the encrypted one .. possible ?
May 31, 2016 at 3:53 am
No.
The passwords aren't encrypted. They're hashed and cryptographic hashes are one-way processes. You cannot extract the plain-text password from the hash.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2016 at 7:46 am
You can however retrieve and later or on another server recreate logins giving the hashed password; i.e. even though you can't read it, the user will still be able to use his original password.
select name, password_hash
from sys.sql_logins sql
where type = 'S'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply