In this article, we will learn how to create a login in SQL.
Let’s follow the below steps to create a new login in SQL Server.
Step 1:
Firstly, Open Microsoft SQL Server Management Studio and then expand your instance and Security directory.
Step 2:
Now, Right-click on Logins directory and click on the New Login… option.
Step 3:
Now, ‘Login – New‘ dialogue box will open. Select SQL Server authentication and then enter your new Login name (TestLogin) and Password and then click on the OK button.
Step 4:
Now, refresh Object Explorer and check new login (TestLogin) is created.
Also, check How To Generate Script in SQL
