Take the following steps to enable mixed mode authentication on the SQL Server:
- Open SQL Server Management Studio Express.
- Choose Windows Authentication from the Authentication drop down list.
- Click Connect to open the Microsoft SQL Server Management Studio Express window.
- Right-click the SQL instance and choose Properties to open Server Properties window.
- Click Security on the left hand side.
- Choose SQL Server and Windows Authentication Mode on the right side.
- Click OK to close the Server Properties window.
- Right-click the SQL instance and choose Restart.
- Click Yes to restart the SQL server.
Take the following steps to enable the System Administrator login:
- Open SQL Server Management Studio.
- Choose Windows Authentication from the Authentication drop down list.
- Click Connect to open the Microsoft SQL Server Management Studio window.
- Expand Security > Logins.
- Right-click sa and click Properties.
- Click Status and check the box for Login Enabled.
Note: You may have to give the system administrator account a password at this time as well.
