Q

Best practices to encrypt passwords in SQL Server 2000

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 SQLSecurity.com. Here are some MS articles to get you started:
This was first published in June 2003

Dig deeper on User passwords and network permissions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchVirtualDesktop

SearchWindowsServer

SearchExchange

Close