MSSQL: Enable Mixed Mode Authentication

To enable mixed mode authentication in Microsoft SQL Server, you'll need to follow these steps:

1. Open SQL Server Management Studio and connect to your SQL Server instance.
2. Right-click the server name in the Object Explorer and select "Properties".
3. In the "Server Properties" window, select the "Security" page.
4. Under the "Server authentication" section, select "SQL Server and Windows Authentication mode" and click "OK".
5. A dialog box will appear asking you to restart the SQL Server service. Click "Yes".
6. After the service has restarted, you should be able to use both SQL Server authentication and Windows authentication to connect to the server.

Keep in mind that enabling mixed mode authentication may increase the security risk of your SQL Server instance, as it allows users to authenticate using either a SQL Server login or their Windows credentials. It's a good idea to use strong passwords for SQL Server logins and to regularly review and update the permissions of your users and groups to minimize the risk of unauthorized access.