Need Opinions: Should an ASP.NET Application allow administrators to change MSSQL connection?
- by Brent Pabst
As the title suggests:
What is your opinion on allowing administrators to update the SQL Connection string dynamically from the application versus just showing them the connection details in the application?
Because the database connection is so important and on a heavily used system the abrupt change to the connection seems like it could cause problems. However I would think displaying the server and catalog and whether the connection is using SSPI or SQL Auth could be helpful for administrators who don't like playing with .NET config files.
Thoughts?