Creating new Database User in SQL Server using Management Studio


Follow below steps to create a database user using SQL Server Management Studio.

1) Open SQL Server Management Studio and open "Object Explorer" and expand "Databases" folder.

2) Select and expand the database in which to create the new database user.

3) Select and expand "Security" menu. Right-click the "Login" folder, click to "New Login...".

SQL Server Security Login

4) It will open "Database user - new" window navigate to "General" tab from the left.

5) Provide "User name" and "Login name" in boxes provided.

SQL Server username password

6) Click "OK" button to finish the wizard.

Your feedbacks are most welcome..