After installing SQL (in this particular case, SQL Express 2012), if you install it using "Windows Authentication", is there a way to, after the fact, enable mixed mode authentication?
I installed using Windows Authentication and am able to do anything I want using SQL Management Studio and Windows Authentication.
However I have an app that needs to connect using SQL server authentication, so even though I've set up accounts with permissions, I can't seem to use them to connect via ODBC
(using sql logins) nor connect using SQL Server authentication in the SQL Management studio. What am I missing here?
Is it because I didn't install and select "SQL Server Authentication" (or mixed mode?) during the install?
If so, can you "enable this after installation?" (If so I have had no luck finding the "switch" to do this).
Does it require an uninstall and reinstall?
Any help would be appreciated.