Create MS SQL new Login

How to create new user on MS SQL?

1. Open MS Sql Management Studio.
2. Log in via Windows Authentication.
3. Open Security Folder.
4. Open Logins  Folder.
5. Right Click -> New Login...
6. Write the user name.
7. Select the Sql Authentication 
8. Type a password 
9. Pick the DB which this user should manage.

Look @ the figure bellow 

      10. Press on User Mapping, Pick the DB which you want this user to manage and select the memberships     rules. look at the Figure bellow.

         11. The Status Tab should be as the following Figure.

    12. Press OK.
    13. Right click on Server name -> Properties 
    14. Press on Security tap and Pick SQL server and windows authentication mode under Server Authentication section. Look @ the figure bellow

Best Wishes,


Mohammad Abu Hmead.