How to Change Windows Authentication to SQL Authentication In Microsoft SQL Server Management Studio

In Microsoft SQL Server Management Studio (SSMS), you can change the authentication mode from Windows Authentication (also known as Integrated Security) to SQL Server Authentication. Here's how you can do it:

Connect to SQL Server:
Open SQL Server Management Studio and connect to the SQL Server instance.

Open Server Properties:

In the Object Explorer, right-click on the server name.
Select "Properties" from the context menu.
Go to Security Tab:

In the Server Properties dialog box, navigate to the "Security" tab.
Change Authentication Mode:

Under "Server authentication," you'll see two options:

Windows Authentication mode
SQL Server and Windows Authentication mode
Choose the second option ("SQL Server and Windows Authentication mode").

Restart SQL Server:

After changing the authentication mode, you will need to restart the SQL Server service for the changes to take effect.
Connect Using SQL Server Authentication:

Once SQL Server is restarted, you can now connect using SQL Server Authentication.

Видео How to Change Windows Authentication to SQL Authentication In Microsoft SQL Server Management Studio канала AVEIT