asked on

Encrypt password in connection string in web config file

Hi,

Please help... Can someone show me how to encrypt the password in the connection string in a webconfig file. I am using VS 2010. I need some specific instructions, since i hardly know C#.

For you information this is what i am trying to do.. I am developing an application and need to give all my code out to a developer. I myself write all the sql server code and it is hosted in Azure. So my thought was that it should not be a problem if i can set the connection string to point to azure... but i need to encrypt it.

Thanks so much in advance,
Joy

joygomez1964

ASKER

BTW this is my connection string.

<connectionStrings>
<add name="ForWebAEntities4" connectionString="metadata=res://*/Models.Model1.csdl|res://*/Models.Model1.ssdl|res://*/Models.Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=tcp:abc.database.windows.net;initial catalog=ForWebB;integrated security=False;user id=joygomez@l1t8a;password=123456;multipleactiveresultsets=True;encrypt=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>

ASKER CERTIFIED SOLUTION

David Johnson, CD

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Roopesh Reddy

Hi,

Consider @ve30fa suggestion!

Added to his info, check this cool article as well - http://www.codeproject.com/Tips/304638/Encrypt-or-Decrypt-Connection-Strings-in-web-confi

It has explained clearly!

Hope it helps u...

Amandeep Singh Bhullar

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.