Methods to change windows authentication to mixed mode (windows and SQL server authentication)

 

Hey guys, In this blog I am going to explain you about different methods to Enable Mixed Mode authentication

Ø Enable Mixed mode authentication using Management studio

Ø Enable Mixed mode authentication using Registry editor

1.              Enable Mixed mode Authentication using MANAGEMENT STUDIO-

STEP-1: Open a server in Management studio.

               Go to server -> right click -> instance ->properties

           

Fig-1

STEP -2: Go to security and change Server authentication from Windows authentication

                 to SQL Server and Windows Authentication mode as shown below  

Fig -2

STEP -3: Click Ok and Restart the SQL Server Services

2.            Enable Mixed mode authentication using REGISTRY EDITOR-

STEP -1: Go to search and type registry editor and press Enter >

STEP -2: Go to HKEY_LOCAL_MACHINE -> SOFTWARE -> Microsoft -> 

                Microsoft Server -> MSSQL 15. MSSQLSERVER -> MSSQL Server -> 

                Login Mode as shown below in Fig -3 and Fig -4

                             

Fig -3

Fig -4

STEP -3 – In Login mode, change value data from 1 to 2 to enable the Mixed mode as shown below,

                          Fig -5

STEP -4: Click ok and restart the SQL server Services