How to enable Mixed Mode Authentication in SQL Server?
Following are the steps to enable mixed mode authentication:
- Connect to the server in object explorer
- Right Click On The Server And click on properties
- Now select Security Option in the “Select a page” Section
- In the Server Authentication on the right side select “SQL Server And Windows Authentication Mode”
- Click On Ok.
This enables both SQL Server authentication and windows authentication to access the SQL Server