for our apps we use db's and tables that are populated with usernames, server, db, login and password

app starts up and checks the db and table for the credentials it will use to access sql. this way all we have to do is make a few changes to point apps to another server