Encrypt the password in SQL 2000

5 pts.
Tags:
ASP
SQL Server 2000
SQL Server encryption
SQL Server security
VB
How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to pass the encrpted value to in the password portion of the connection string. Can anyone help me out on this. Can I create a DLL? How to perform this...please advice at the earliest.

Answer Wiki

Thanks. We'll let you know when a new response is added.

There’s no way to pass the password in an already encrypted form. What you can do, it store the connection string in an encrypted form in the config file, then when the app loads, load the encrypted connection string, and decrypted it in memory and use the then decrypted connection string to connect. This way the entire connection string is stored encrypted not just the password.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following