Users Guide

Table Of Contents
Configuring the Database Instance
The SQL Server service will not start if you are using the default NETWORK SERVICE or LOCAL SYSTEM accounts. Therefore, you
must configure the SQLEXPRESSOME database instance to run using a domain service account.
To configure the SQLEXPRESSOME database instance:
1. Open Microsoft SQL Server Configuration Manager.
2. On the left pane, click SQL Server Services.
3. On the right-pane, right-click SQL Server (SQLEXPRESSOME) and click Properties.
The SQL Server (SQLEXPRESSOME) Properties window is displayed.
4. In the Log on tab, select This account.
5. Type the domain service account name, password, and confirm the password in the appropriate fields.
6. Click Restart.
7. Click Apply
Adding Users to the OpenManage Essentials User Groups
To add users to the OpenManage Essentials user groups:
NOTE: The users you add to the OpenManage Essentials user group must also belong to the built-in local Administrator
group. For information on adding a Windows user account to a group, see “Adding a user account to a group” at
support.microsoft.com
1. Open Server Manager.
2. Click ToolsComputer Management.
3. In the left pane, click Local Users and GroupsGroups.
4. In the right-pane, right-click OmeAdministrators and select Add to Group.
5. In the OmeAdministrator Properties window, click Add.
The Select Users window is displayed.
6. In the Enter the object names to select field, type the user name.
7. Click Check Names and then click OK.
The user name is displayed in the Members list within the OmeAdministrator Properties window.
8. Click OK.
Enabling SQL Server and Windows Authentication Mode in SQL Server
To enable SQL Server and Windows authentication mode:
1. Open SQL Server Management Studio.
2. In Obejct Explorer, right-click the top-level SQL Server object and click Properties.
The Server Properties window is displayed.
3. In the left pane, click Security.
4. In the right pane, under Server authentication, click SQL Server and Windows Authentication mode.
5. Click OK.
6. In Obejct Explorer, right-click the top-level SQL Server object and click Restart.
Verifying SQL Server TCP/IP Status
To verify the TCP/IP status of SQL Server:
1. Click StartAll ProgramsSQL Server Configuration Manager
NOTE: If multiple versions of SQL Server Configuration Manager are installed, ensure that you select the latest
version.
2. On the left pane, click to expand SQL SQL Native Client 11.0 Configuration.
31