SQL Server authentication changed to mixed authentication mode step _mssql

1. Start SQL Server Management Studio and log on as a Windows authentication method.

2. In the Object Explorer window, right-click the server, select Properties, and open the Server Properties dialog box.

3. On the Security page, under Server Authentication, select the new server authentication mode, and then click OK.

4, restart the SQL Server service, you can directly through the right key click "Object Explorer" to start.

5. Enable SA user using this statement: ALTER LOGIN SA enable

6. Set the SA user's password: ALTER login SA with password= ' your password '

Ok, disconnect now, and then use SQL Server Authentication to try to log in with the SA user.