This tutorial will show the steps of creating a new user with SQL Server Authentication. In this tutorial, we are using SQL Server 2017.
Steps to create User with SQL Server Authentication:
Step 1: Login to MS SQL Server using windows authentication as shown below:
Step 2: Expand the Security tab and then Right-click on the Login option. Click on option New Login as shown below:
Step 3: Now in New Login Dialog under the General tab enter the following detail. Enter new user Login Name, Enter the new password. If you want to enforce password policy then leave the checkbox as selected as shown in below screenshot:
Step 4: Once entered all new SQL user detail in step 3 click on Ok button. Disconnect from the server, now you can see the SQL server login window again.
Now you have to select the Authentication as SQL Server Authentication. Enter New User Login name and Password as shown below:
Finally, you will be successfully logged into the server using SQL Server Authentication with a new user.