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 ->

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

Clota Blog