How to enable SQL Server authentication

By FoxLearn 6/26/2024 2:59:12 AM   2.72K
Changing the Server Authentication Mode in SQL Server involves a few steps.

First, Open SQL Server Management Studio (SSMS), then you need to login to your sql server windows authentication mode.

login 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

Under the Server authentication section, you will see two options:

Windows Authentication mode: This is the default and only allows Windows authentication (recommended for security).

SQL Server and Windows Authentication mode: This allows both Windows Authentication and SQL Server Authentication.

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

change server authentication mode in sql server

Changing the authentication mode might require you to restart the SQL Server service for the changes to take effect. SSMS will typically prompt you if a restart is necessary.

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.