SQL 2008 authentication: safe to change from Windows to mixed mode ?
Posted on 2013-01-14
I have been asked to use an existing SQL 2008 server for a new database for a new client-server app. Currently, SQL authentication on this SQL server is Windows and it is being used for a production line-of-business app. However, the new app requires mixed mode authentication. I know how to change from Windows to mixed authentication. However, is it safe to do this? Are there likely to be any implications for the original app?