Encrpt password in sp_addlogin

Question

Encrpt password in sp_addlogin

Larry C

Default port

Points: 1493
More actions
February 26, 2004 at 12:46 pm

#84043

Is there a way to encrypt a password when you are setting up a new login via sp_addlogin stored procedure?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 1

You could create your own stored procedure wich have the same parameters of sp_Addlogin.

Pass the encripted password to your sp, desencript it and then from with in the sp, call sp_Addlogin and pass the password.

noeld SSC Guru Points: 96590 More actions · Answer 2

following the racosta great suggestion a good thing would be to let a job doit for you

* Noel

Kurt Anderson SSC Rookie Points: 35 More actions · Answer 3

The sp_addlogin already contains an encryption option parameter with flags.

The first one uses the undocumented (see here: http://www.nextgenss.com/papers/cracking-sql-passwords.pdf) pwdencrypt function to encrypt.

The second allows you to pass in an already encrypted (best option) password for storage as part of the process.

The third is for migrating previous logins from a prior version of SQL Server. You can look this up in the Transact-SQL Help by searching for sp_addlogin.

============================================================================

Oxymoron is not an acne cream for idiots.