How do I enable mixed mode authentication in MS SQL?

You can configure MS SQL Server Authentication to run in Mixed Mode i.e. log in to a MS SQL Server using either your Windows username and password or your SQL Server username and password. The following article shows to enable the Mixed Mode in MS SQL Server 2005.

1. Click Start > All Programs > MS SQL Server 2005 > SQL Server Management Studio. The SQL Server Management Studio will now be launched.
2. Enter your login details and connect to the server.
3. Right click the Server name and select Properties. The Server Properties window will now be launched.
   
4. Select the Security node in the left pane.
5. In the Server authentication section select the SQL Server and Windows Authentication mode.
   
6. Click the OK button to apply the changes.
7. Now, right click the server name and select Restart. The service will now be restarted.

That’s It!