Users Guide

Related References

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.

Numb

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

version 1.3 or 2.0 to version 2.0.1 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.

Events Database Size

Initial database size 60 MB

After discovery and inventory of 4000 devices 65 MB

After 2000 alerts are generated 73 MB

After tasks (status polling, OpenManage Server

Administrator deployment tasks, remote tasks, and

77 MB