How to create SQL Server Login with SQL Server Management Studio

Create a SQL Server login that uses Windows Authentication

1.In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.

2.Right-click the Security folder, select New, and then click Login.

3.Enter the name of a Windows user in the Login name box.

4.Select Windows Authentication.

5.Click OK.

Create a SQL Server login that uses SQL Server Authentication

1.In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.

2.Right-click the Security folder, select New, and then click Login.

3.Enter a name for the new login in the Login name box.

4.Select SQL Server Authentication.

5.Enter a password for the login.

6.Select the password policy options that should be applied to the new login.

7.Click OK.