How to enable SQL Server authentication
By FoxLearn 10/28/2020 4:59:17 AM 2.66K
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
Right click on "sa" user, then select Properties.
Next, Select General
Entering your sql password, then click Status
Selecting Enabled login, then click OK button.
Right-clicking on your SQL Server, then select Properties
You need to change from "Windows Authentication mode" to "SQL Server and Windows Authentication mode", then click OK button.
Right-clicking on your SQL Server, then select Restart.
Entering your user and password, then connect to SQL Server.
- SQL Server Migration Assistant
- How to Download and Restore Northwind database to SQL Server
- How to use SQL INSERT INTO SELECT Statement
- Data type SQL Server
- How to drop table if exists in sql server
- How to fix 'The specified directory for the INSTALLSHAREDDIR parameter is not valid'
- How to get all table names of a particular database using TSQL
- How to use ROW_NUMBER Function in SQL Server
Categories
Popular Posts
Visual Studio: Auto increment version
04/01/2024
What is ARM architecture?
04/01/2024
How to use Factory Method Pattern in C#
02/16/2024