We have windows application with multiple modules and every unit in organization has different module. Right now my system working on SQL 2000 datbase and organization is moving from 2000 to 2008 database.
Now, Company has decided to move from Sql Authentication to Windows Authentication. So my connection string will change and i need to change it in all the modules, all related autoprocess and deploy new exe in all the pc around 500.
Can anyone suggest me that is the good idea to go with Mix mode authentication so i do not need to change connection string?