Enable Mixed Mode Authentication
Posted on : 28-06-2011 | By : Devi Prasad | In : SQL Server Basics, SQLServerPedia Syndication
0
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
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.
Tags: asp.net mixed authentication, Configure Microsoft SQL Server for Mixed Mode Authentication, Mixed Mode Authentication in SQL Server, sql authentication mode, sql mixed mode, SQL Server 2005 mixed mode authentication, SQL Server 2008 mixed mode authentication, SQL Server 2011 mixed mode authentication, sql server authentication
