you can simple save the connection string in a text file and then include that file in your application..
when your password is changed then just replace the key in the text file and it will automatically picked by the applications..
you can place more than one connection string in the text file.
Thanks for the reply - I think it's very useful, if we are able to include multiple connection strings in the text file, it may just acheive our purpose.
Just to tap on your expertise - from your past implementations is there any best practice for managing the security of this text file? Anybody who has access to it will effectively have access to the databases so it is very important from a security point of view.
Thanks in advance!