Users Guide

Table Of Contents
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.
Related links
Minimum Login Roles for Microsoft SQL Server
Minimum Login Roles for Microsoft SQL Server
The following table provides information about the minimum permissions for SQL Server based on different installation and upgrade
use cases.
Table 4. Minimum Login Roles for Microsoft SQL Server
Number Use Case Minimum Login Roles for SQL Server
1 Installing OpenManage Essentials for the first time and you
select the Typical option during the installation process.
sysadmin access on the installed instance.
2 Installing OpenManage Essentials for the first time, you
select the Custom option during the installation process
and an empty OpenManage Essentials database is present
(locally or remotely).
NOTE: If you select the Custom install option and
do not enter any credentials then the installation is
considered as a Typical installation and sysadmin
rights are required.
db_owner access on the OpenManage Essentials
database.
3 You are installing OpenManage Essentials for the first time,
you select the Custom option during the installation
process, and an empty OpenManage Essentials database is
not present.
dbcreator access on the server.
4 Upgrading OpenManage Essentials from an earlier version
to the latest version and an OpenManage Essentials
database is present (locally or remotely).
db_owner access on the OpenManage Essentials
database.
Database Size and Scalability
The following table provides information about the changes to the database size in an environment with 4000 devices based on
alerts, tasks, and alert actions.
23