White Papers

ManualsBrandsDell ManualsActive System ManagerEMC OpenManage Essentials Version 2.5

Installation procedure

13 Installing Dell EMC OpenManage Essentials

SQL Server requirements include:

• Local Database:

To set up the OME on a local database, SQL Server 2008 R2/2012/2014/2016 Standard/

Enterprise/Datacenter edition or SQL Server 2008 R2/2012/2014/2016 Express edition with

SQLEXPRESSOME instance name must be installed. (Though it is a warning prerequisite).

• Remote Server:

If you have a database located on the remote server, SQL Server is not required on the local system.

• Version:

If the local system has SQL Server 2005/2008 installed, it is recommended to install SQL Server

2008 R2 or SQL Server 2012. The OME is not supported on SQL Server 2005 and 2008.

• Collation:

OME is supported only on a case-insensitive instance of SQL Server.

Note—MS SQL Server 2012 RC or Evaluation versions are not supported. The ‘Always On Availability

Groups’ feature of SQL Server is not supported by the OME database.

3.4 Select SQL server instance

Different instances of SQL Server will be selected by installing OME in different scenarios. Automatic instance

selection is different when Express or Standard, Enterprise, or Datacenter editions of SQL Server are

installed on the local system. If the OME needs to be configured on the remote database, you can select any

instance of SQL Server 2008 R2, 2012, 2014, or 2016 (Standard, Enterprise, Datacenter, or Express

editions). To know more about the instance selection logic of the OME installer during typical install, see

Table 5.

Table 5 Local Database Instances Supported

SQL Version

SQL Edition

Instance Name

Prerequisi

te Status

Prerequisite

Message

Required

Action

None

Warning

No SQL

found

Click to install

2005/2008

Standard/Enterpri

se/

Datacenter

Default

Warning

supported

SQL found

Click to install

Custom Name

Warning

supported

SQL found

Click to install

2005/2008

Express

Default

Warning

supported

SQL found

Click to install

Custom Name

Warning

supported

SQL found

Click to install

2008 R2/2012

/2014/2016

Standard/Enterpri

se/

Default/Custom

Name

None