Dell EMC OpenManage Essentials Version 2.5 User's Guide

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 1. Minimum login roles for Microsoft SQL Server. Information about the minimum permissions for SQL Server based on different installation and upgrade use cases.
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.

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