This article from InSource shows how to enable SQL Server Mixed Mode if it was not selected during installation.
- Author: Mike Viteri
- Published: 9/21/2015
- Applies to: Microsoft SQL Server
Mixed Mode will have to be enabled in two places.
- Enable the SA Account
Inside SQL Server Management Studio. Go Under Security->logins then SA Account. Right click on this account and go to properties. Click on status make sure login is set to enable. You should reset your SA password.
- Enable SQL Server Authentication
Next you will have to right click on your SQL Server in Management Studio. Select properties then choose security. Make sure SQL Server and Windows Authentication is selected.
Now restart your SQL Server instance or restart the computer and you can now login with your SA account.