I am having a problem with an ASP.NET app I am writing. I need to find a way to store multiple, dynamic connection strings to a database. These need to be updatable via a web interface (in a protected admin page).
I initially tried having one main connection string in the web.config as usual, and grabbing the others from the database itself, but this is resulting in too much unnecessary database i/o.
I have since been looking into moving all of the AppSettings section of the web.config file to another config file, and making this writable, so the ASP.NET user account can update it when the application starts. Whenever I try this, I am getting permissions errors (access denied), even when I give full control of the file to the ASPNET user (i have also tried impersonation, and giving full control of the file to the IUSR account, still no luck).
Every time I try, IE prompts me for a username and password.
Does anybody know what is going wrong and how I can fix it?
Thanks!
Adam
I initially tried having one main connection string in the web.config as usual, and grabbing the others from the database itself, but this is resulting in too much unnecessary database i/o.
I have since been looking into moving all of the AppSettings section of the web.config file to another config file, and making this writable, so the ASP.NET user account can update it when the application starts. Whenever I try this, I am getting permissions errors (access denied), even when I give full control of the file to the ASPNET user (i have also tried impersonation, and giving full control of the file to the IUSR account, still no luck).
Every time I try, IE prompts me for a username and password.
Does anybody know what is going wrong and how I can fix it?
Thanks!
Adam
Last edited:
