Database considerations
Using ePolicy Orchestrator with a database
A database must be installed before ePolicy Orchestrator can be installed. Any of the following
databases, if previously installed, meets this requirement.
• SQL Server 2005
• SQL 2005 Express
• SQL 2008
• SQL 2008 Express
NOTE: SQL 2000 is not supported.
If none of those databases was previously installed, the ePO installation wizard detects that no
database is present and offers you the opportunity to install SQL Server 2005 Express.
Database Requirements Note
Dedicated server and network Needed if managing more than 5,000 computers.
connection
SQL Server 2005
or SQL Server
2008
If the database and ePO server are on the same system,
McAfee recommends using a fixed memory size in Enterprise
Local database server
Manager or SQL Server Management Studio that is
approximately two-thirds of the total memory for SQL Server.
For example, if the computer has 1 GB of RAM, set 660 MB
as the fixed memory size for SQL Server.
A license is required for each processor on the computer
where SQL Server is installed. If the minimum number of SQL
Licenses
Server licenses is not available, you might have difficulty
installing or starting the ePolicy Orchestrator software.
SQL Server 2005 .NET Framework You must acquire and install.
Express
Software Note
MSXML 6.0 You must acquire and install.
1 From the Internet Explorer Tools menu, select Windows
Update.
2 Click Custom, then select Software.
3 Select MSXML6.
4 Select Review and install updates, then click Install Updates.
Pre-Installation
System requirements
Software Note
Internet Explorer 7 or 8, or You must acquire and install.
Firefox 3.0
.NET Framework 2.0 You must acquire and install if using SQL Server 2005 Express.
Microsoft Visual C++ If not previously installed, the installation wizard installs automatically.
Redistributable
Microsoft Visual C++ If not previously installed, the installation wizard installs automatically.
Redistributable - x86 9.0.21022
MDAC 2.8 If not previously installed, the installation wizard installs automatically.
SQL Server 2005 Backward If not previously installed, the installation wizard installs automatically.
Compatibility
If no other database has been previously installed, this database can be installed
automatically at user’s selection.
SQL Server 2005 Express
Update the ePolicy Orchestrator server and the database server with the most
current updates and patches.
Microsoft updates
MSI 3.1 The installation fails if using a version of MSI previous to MSI 3.1.
Database installation documented in this guide
The only database installation scenario described in detail is a first-time installation of SQL
Server 2005 Express. In this scenario, the ePolicy Orchestrator Setup installs both the ePolicy
Orchestrator software and the database on the same server. If the database is to be installed
on a different server from the ePolicy Orchestrator software, manual installation of SQL is
required on the remote server.
Other relevant database installations and upgrades
See the documentation provided by the database manufacturer for information about the
following installation scenarios:
• Installing SQL Server 2005 or 2008.
• Upgrading from MSDE 2000 to SQL Server 2005 or 2008.
• Upgrading from MSDE 2000 to SQL Server 2005 Express.
Nested triggers — The SQL Server Nested Triggers option must be enabled.
Database collation — The only database collation supported by ePolicy Orchestrator is the
U.S. English default: SQL_Latin1_General_Cp1_CI_AS.
Maintenance settings — McAfee recommends making specific maintenance settings to ePolicy
Orchestrator databases. For instructions, see Maintaining ePolicy Orchestrator databases in the
ePolicy Orchestrator 4.5 Help.
SQL Server
Dedicated server and network connection — Use a dedicated server and network connection
if managing more than 5,000 client computers.
Local database server — If using SQL Server on the same system as the ePolicy Orchestrator
server, McAfee recommends using a fixed memory size in Enterprise Manager that is
approximately two-thirds of the total memory for SQL Server. For example, if the computer has
1 GB of RAM, set 660 MB as the fixed memory size for SQL Server.
Pre-Installation
System requirements
SQL Server licenses — If using SQL Server, a SQL Server license is required for each processor
on the computer where SQL Server is installed.
CAUTION: If the minimum number of SQL Server licenses is not available after you install the
SQL Server software, you might have issues installing or starting the ePolicy Orchestrator
software.
Distributed repositories
Free disk space — 400 MB on the drive where the repository is stored.
NOTE: The disk space requirement for the distributed repositories on agents that are designated
as SuperAgents is equal to the disk space available for the master repository.
Memory — 256 MB minimum.
Possible hosts:
• HTTP-compliant servers on Microsoft Windows, Linux, or Novell NetWare operating systems
• Windows, Linux, or NetWare FTP servers
• Windows, Linux, or UNIX Samba UNC shares
• Computer with a SuperAgent installed on it
[NOTE; no more today, we will jump next stage tomorrow, now forget about it and go back as we were doing]