Okay, I found a link online walking me through how to encrypt the connection string portion of the web.config file. Is there anyone who's ever done this that can answer a couple of questions for me? I tried googling the answers but nothing came up that explained what I needed to know.
A little background as to why we are doing this. I need to download data from an outside source that my supervisor has access to. He wants me to download this data daily rather than monthly (which he has to do for me). He wants to put in his user name and password for the connection information and then we'll encrypt it so I can't see his log on information.
The questions I have are as follows:
1. Can you encrypt a development connection string? The instructions I see seem to show it being encrypted after it's deployed.
2. Once you encrypt the connection string information can you add other connection strings? If yes, do you need to decrypt and re-encrypt or are they added without encrypting?
3. Also he has to reset his password every 60-90 days. Does that mean he'll have to decrypt the connectin string, input his new password and then re-encrypt it again?
If you don't have experience with this but know a good on-line source I'd take that also. I just want to understand how this is going to work before I try to implement it.