Create and configure a user in MSSQL

Use the following steps to create and configure a user in MSSQL®:

  1. Open the Microsoft ® SQL Server® Management Studio (SSMS).

  2. Connect to SQL Server by using your login information.

  3. In the left-hand panel, expand Security > Logins.

  4. Right-click Logins and select New Login from the drop-down menu.

  5. Assign a login name and select the authentication method and default database or language.

    If you are using SQL authentication, you must enter an initial password and choose the
    enforcement options for password policy and expiration as well as whether or not the user
    needs to change their password when they log in.

  6. In the left-hand panel, click Server Roles to assign any server roles you want
    this user to have, including bulkadmin, dbcreator, public, and so on.

  7. In the left-hand panel, click Securables and then click Search.

    The Add Objects dialog box displays, where you can choose specific objects, objects of a
    certain type, or the server itself. Select one and click OK.

  8. On the Securables page, select Grant, With Grant, or Deny as necessary for any of the
    objects in the explicit box.

    Grant gives access to the securable, With Grant allows the user to grant access to the
    securable, and Deny expressly denies permission to the securable no matter what roles or
    permissions the user might have.

  9. In the left-hand panel, click Status to grant or deny permission to the database engine,
    enable or disable the login, and to unlock the account should it get
    locked out.

When you have finished modifying the settings, click OK to create the user and exit the new login creation window.