Enable Mixed Mode Authentication

Posted on : 28-06-2011 | By : Devi Prasad | In : SQL Server Basics, SQLServerPedia Syndication


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

Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.

Your Ad Here

Tags: , , , , , , , ,