Posted on: 3/29/2011 11:56:09 AM | Views : 1241

By default, when using Forms Authentication to validate against a SQL database, all the Forms Authentication samples utilizes the connection string from the web.config file. Is there a way of specifying the connection string for Forms Authentication to use, programatically at runtime?
Without going into great details, my web app will be utilizing different databases depending upon other factors. So, sometimes, the app will be utilizing Database1, and other times, Database2. Both databases will have the same Forms Authentication tables, just different values.
I'm hoping there is a simple way of just specifying the database connection string to utilize, without having to go so far as to start implementing my own custom providers.  Yet, I haven't come across any documentation that talks about how to do that (yet).
Thanks in advance,
Richard
 
...

Go to the complete details ...