Enable Mixed Mode Authentication

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.
enable mixed mode authentication sql server
enable mixed mode authentication sql server

This enables both SQL Server authentication and windows authentication to access the SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *