How to enable SQL Server authentication

This post shows you how to change Server Authentication Mode in SQL Server.

First, you need to login to your sql server windows authentication mode.

Selecting Security

enable sa user in sql server

Right click on "sa" user, then select Properties.

enable sa user sql

Next, Select General

enable sql user

Entering your sql password, then click Status

enable user login sql server

Selecting Enabled login, then click OK button.

Right-clicking on your SQL Server, then select Properties

enable user mode in sql server

You need to change from "Windows Authentication mode" to "SQL Server and Windows Authentication mode", then click OK button.

Change Server Authentication Mode in SQL Server

Right-clicking on your SQL Server, then select Restart.

Change Server Authentication Mode in SQL Server

Entering your user and password, then connect to SQL Server.