By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
What's the best way or algorithm to encrypt and decrypt the password column values in MS SQL Server 2000? We need to encrypt with a custom security application and decrypt before replicating this data to many other heterogeneous systems. We will also need to call these systems' encryption mechanisms before inserting and updating password data during the replication on the target systems. One of the targets includes Active Directory. We are assuming that it can be encrypted in AD and then replicated to other LDAP servers like Sun SourceOne.
Whoa, application design in SQL Server for compatibility with Sun SourceOne is a little out of the focus here. However, some good places to start are Microsoft Crypto API and Data Protection API (DPAPI) documentation and
. Here are some MS articles to get you started: