using asp4 mvc 3 building web app.
I am deploying a web app outside the company firewall, so I want to secure the connection string to the database in some way. The connection string is in the web config.
Do I even need to do anything? Meaning is there already built in stuff, it will be sitting on Windows Server 2008, using IIS7.
One option I have been looking at is using the asp_regiis.exe tool, but I have questions due to conflicting info in tutorials:
a. If the code is on my box and I run the tool, do I need to rerun it after it is deployed to server?
b. Some tutorials say the decrypt is built into the framework, so once I to the one time encryption using the tool, I don't have to worry about it, but one or two talk about how to decrypt, so I am not sure if it automated. Is it?
c. Do I have to do any setup on the server at all, like tell the app pool it using an encrypted web config file?
Is there a way to just encrypt the password? Maybe on creation of the model.edmx file? I am more than happy to delete it and recreate it if there is.