Dell EMC OpenManage Essentials Version 2.5 User's Guide

Creating a new user in SQL Server

To create a new user in SQL Server:
  1. Open SQL Server Management Studio on the system where you restored the OpenManage Essentials database.
  2. In Object Explorer expand the Security node.
  3. Click Login > New Login . The Login - New window is displayed.
  4. In the General page:
    1. Type a name in the Login name field.
    2. Select Windows authentication or SQL Server authentication based on your preference.
    3. Type the password and reconfirm the password in the appropriate fields.
    4. Optional: If you want to enforce password policy options for complexity, select Enforce Policy Password.
    5. From the Default database list, select OMEssentials.
    6. From the Default language list, select a default language for the login.
  5. In the Server Roles page, select public.
  6. In the User Mappings page:
    1. Under Users mapped to this login, select OMEssentials.
    2. Under Database role membership for: OMEssentials, select db_owner and public.
  7. Click OK.
The new user that you created is displayed under Security > Logins in Object Explorer.

Rate this content

Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\