Dell EMC OpenManage Essentials Version 2.5 User's Guide

Terms and conditions for using Relational Database Management Systems

The Relational Database Management System (RDBMS) used for installing OpenManage Essentials is Microsoft SQL Server. SQL Server has configuration settings separate from the OpenManage Essentials database. The server has logins (SQL or Windows) that may or may not have access to the OpenManage Essentials database.

When OpenManage Essentials is installed, Internet security is modified by adding registry entries to the ZoneMaps for HKLM and HKCU. This ensures that Internet Explorer identifies the fully qualified domain name as an intranet site.

A self-signed certificate is created and this certificate is installed in the root Certificate Authorities (CA) and My certificates.

To prevent certificate errors, remote clients must either install OpenManage Essentials certificate in both CA and Root Certificate Stores or have a custom certificate published to client systems by the domain administrator.

For a typical installation of OpenManage Essentials:
  • Use the local instance of SQL Server that has all supported components.
  • The RDBMS is altered to support both SQL and Windows authentication.
  • An SQL Server login user is generated for OpenManage Essentials’ services. This login is added as a RDBMS SQL login with the dbcreator role and given the db_owner role over the ITAssist and OMEssentials databases.
  • NOTE: The password for the typical install, auto generated SQL Server login account, is controlled by the application and different on every system.

For the highest level of security, it is recommended that you use a domain service account that is specified during custom installation for SQL Server.

At runtime, when the OpenManage Essentials website determines that it has an invalid certificate or certificate binding; the self-signed certificate is regenerated.


Rate this content

Accurate
Useful
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: <>()\