
For more information about the specific standard SQL database roles required for your McAfee ePO
server to operate once installed, see the product guide or Help. For a complete discussion of SQL
Server roles and permissions, see the product documentation for the supported SQL Server you are
using.
Required SQL permissions for installing McAfee ePO
Specific SQL Server roles are required if you plan to use an existing SQL Server or manually install a
new SQL Server.
For new McAfee
ePO installation...
Use these server roles
During installation The user account credentials for either Windows or SQL authentication must
have these server roles granted on the target SQL Server:
• public
• dbcreator
The dbcreator server role is required for the setup program to create and add
the requisite core McAfee ePO database objects to the target SQL Server
during installation.
This McAfee ePO SQL user account is granted the database role permission
db_owner for the McAfee ePO database.
After the database is
installed
The dbcreator server role can be removed from the McAfee ePO SQL user.
Revoking the dbcreator server role restricts the user account to only those
permissions granted to the db_owner database role on the McAfee ePO
database.
For an upgrade or patch
installation...
Use these roles
During installation The user account credentials for either Windows or SQL
authentication must have these server roles granted on the target SQL
Server:
• public
• db_owner
Supported SQL database user name and password formats
Review these supported formats when creating McAfee ePO and SQL database user names and
passwords.
All printable characters in the ISO8859-1 characters set are supported, with these exceptions.
Platform Unsupported password and user name characters
SQL database
• Leading spaces, trailing spaces, or passwords that contain only spaces
• Double quotes (")
• Leading backslashes (\)
• Colons in user names (:)
• Semicolons in user names (;)
• Single quotes (")
Installation requirements and recommendations
Things to know before installation
1
McAfee ePolicy Orchestrator 5.1.0 Software Installation Guide
13
Commenti su questo manuale