Get articles everyday as a email directly to your inbox:

Click to publicize, if you like this article :

Login into SQL Server and right click on security tab.

Select New -> Login.

SQL Server Security folder

On Next screen, enter Username and password as shown in below image.

SQL Server Create Login

Click on ok button, a new user with specified credentials will be created.