Sunday, January 30, 2011

Encryption

We have a very good inbuilt function to encrypt any text strings in sql server.

select pwdencrypt('yourname')

Here is how to get sql server login passwords in the encrypted format

SELECT name,CONVERT(VARBINARY(256), password) FROM syslogins
But unfortunately Microsoft hasn't provided anything to do the other way, decrypting the encrypted strings.

This is especially useful when you forget your sql server logins' passwords.

No comments:

Post a Comment