Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Password Encryption in SQl SERVER 2005 Expand / Collapse
Author
Message
Posted Monday, November 19, 2007 5:09 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 24, 2011 9:55 AM
Points: 524, Visits: 219
hi iam having a table called 'Users' having password column.
It already contains some data.
i want to encrypt the password field for exisiting record and for new records which may be added in future.(for security purpose)

please give me detailed Step by step description for data encryption
please dont provide only links
Post #423515
Posted Monday, November 19, 2007 5:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585
Books online has a good example: http://technet.microsoft.com/en-us/library/ms179331.aspx

Regards,
Andras




Andras Belokosztolszki, MCPD, PhD
GoldenGate Software
Post #423518
Posted Monday, November 19, 2007 5:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 24, 2011 9:55 AM
Points: 524, Visits: 219
i have already gone through the microsoft article....
i want encryption by password method.... i dont want to create certificates...
just creating keys, opening them.. assigning it to column(encrypt it)...
and finally decrypt it
Post #423525
Posted Monday, November 19, 2007 6:19 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
Take a look at the EncryptByPassPhrase and DecryptByPassPhrase functions. The Books Online links (which have examples):

EncryptByPassPhrase()

DecryptByPassPhrase()


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #423550
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse