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.
Thanks,
Rob

You can do it with Management Studio. Right-click on the SQL Express instance in the Object Explorer. Select "Properties" and then the "Security" page.
Alternately, in T-SQL:


It's really just a registry entry.

Tim

Worked like a champ! Thanks!
Rob