We can Create SQL Login account. This SQL login account is used to login into SQL Server and accessing data from the database in a Server
Connecting to SSMS and open new query window and write the query.
Creating SQL Login account using the following query.
create login <login-name> with password=’*******’
create login srpv1 with password=’5657′