Introduction
This post shows how to create a new user and administer user creation in SQL 2012.
- Open ssms2012.
- Right click the Security Tab, then new->login.

- When you click that, a new window opens like this:
- Give new instance name, then choose which login method you have to use better you create SQL Auth for Security and maintenance plans mainly this login is helpful.
- Then pick the default database as well as language, then click Ok button.
- After creating user, check whether created or not in the security ->logins tab.