How to enable mixed mode authentication in MS-SQL server

  1. Open the SQL server configuration studio
  2. Login with appropriate admin-level privileges
  3. In the main console, right-click your server and choose “Properties”
  4. Click on “Security”
  5. Under “Server authentication”, ensure that “SQL Server and Windows authentication mode” is selected
  6. Choose OK
  7. You may need to restart the SQL service for the changes to take effect