Before adding a user one must first create a login.
Logins can only be created in the servers
Security-folder (not in the databses
So the login can be created under
<server>/Security -> Right-Click -> New -> Login....
A user with the same name and settings will automatically be added to the databases selected in the
User Mapping tab when creating the login.
- If the user wasn't already created you can create it via
<server>/<database>/Security -> Right-Click -> New -> User. Note that the names of the users and logins must match.
- If you would like to manage the users settings when it was automatically added you can change them in
<server>/<database>/Security/Users/<user> -> Right-Click -> Properties.