MS SQL Server - Login Database

A login is a simple credential for accessing SQL Server. For example, you provide your username and password when logging on to Windows or even your e-mail account. This username and password builds up the credentials. Therefore, credentials are simply a username and a password.

SQL Server allows four types of logins −

A login based on Windows credentials.

A login specific to SQL Server.

A login mapped to a certificate.

A login mapped to asymmetric key.

In this tutorial, we are interested in logins based on Windows Credentials and logins specific to SQL Server.

Logins based on Windows credentials allow you to log in to SQL Server using a Windows username and password. If you need to create your own credentials (username and password,) you can create a login specific to SQL Server.

To create, alter, or remove a SQL Server login, you can take one of two approaches −

Using SQL Server Management Studio.

Using T-SQL statements.

Following methods are used to create Login −

First Method – Using SQL Server Management Studio

Step 1 − After connecting to SQL Server Instance, expand logins folder as shown in the following snapshot.

Step 2 − Right-cpck on Logins, then cpck Newlogin and the following screen will open.

Step 3 − Fill the Login name, Password and Confirm password columns as shown in the above screen and then cpck OK.

Login will be created as shown in the following image.

Second Method – Using T-SQL Script

Create login yourloginname with password= yourpassword 

To create login name with TestLogin and password ‘P@ssword’ run below the following query.

Create login TestLogin with password= P@ssword