Users Guide

Minimum login roles for Microsoft SQL Server
The following table provides information about the minimum permissions for SQL Server based on dierent installation and upgrade
use cases:
Table 2. Minimum login roles for Microsoft SQL Server
Number Use Case Minimum Login Roles for SQL Server
1 Installing OpenManage Essentials for the rst time and you
select the Typical option during the installation process.
sysadmin access on the installed instance.
2 Installing OpenManage Essentials for the rst 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 rst 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.
Recommended database size
The following table provides information about the recommended database size in environments with dierent hardware
congurations for OpenManage Essentials:
Table 3. Recommended database size
Recommende
d database
size
Large deployments Large deployments Large deployments Medium deployments Small
deployments
Number of
devices
8000 5500 2000 500 100
SQL Server
database size
14 GB 10 GB 6 GB 2 GB 1 GB
During the daily maintenance, OpenManage Essentials compresses and optimizes the database. OpenManage Essentials also
downloads updates for managed servers. These updates are saved in the local le system (not in the database) where OpenManage
Essentials is installed.
NOTE: OpenManage Essentials can maintain up to 175,000 task execution history details without any issues. If the task
execution history details exceed 175,000, you may experience problems starting OpenManage Essentials. The earlier task
execution history records are purged when the limit set under Task Settings → Task Execution History Records to be
Retained is exceeded. The task execution history details of few tasks are not purged. For more information, see Task
Settings. It is recommended that you periodically delete task execution history details that you may no longer require or
change the purge settings of task execution history details.
22