Search our database

How to create new database with user login in MSSQL Management Studio

1. Login to your MSSQL managment studio. 1

2. At the left side panel, under Security -> right click Logins -> New Login 2

3. Insert all the details as image. Rememeber to select SQL Authentication 3

4. After created the login, proceed to create Databases 4

5. Insert the database name, then click on “” to assign user to the database.Browse for the user login. 5

6. Click on the user, then click OK 6

7. Verify the database name and user have been entered correctly. Then click Ok. 7

8. You can see now that the new database has been created. Your new user login will also been shown. 8

Tags: , , , , , , ,