• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • Last Modified:

How to Change From Unencrypted Connection String Password to Encrypted?

I currently have a site where the Web.Config file has a SQLServer connection string containing an unencrypted password. I would like to change it to be encrypted. What steps do I complete to make the conversion without messing up the connection?
0
rkulp
Asked:
rkulp
  • 3
1 Solution
 
Munawar HussainPrincipal Software EngineerCommented:
you may put an encrypted connectionstring in webconfig file

to use in your code create a centeralized place a method whilch will read encrypted one and after decrypting will save in the state or you may decrypt everytime before creating a connection to sql server

0
 
rkulpAuthor Commented:
I was hoping for some automatic method built into ASP.Net. Does such a thing exist?
0
 
rkulpAuthor Commented:
bmcvicar,

Thanks. I'll try it and get back.
0
 
rkulpAuthor Commented:
Thanks for the links.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now