Users Guide

• Remote database— Complete the prerequisites. For more information, see Setting Up OpenManage Essentials Database
on a Remote SQL Server. After the prerequisites are complete, click Browse and select the remote system and then
provide the authentication details. You can also set up the OpenManage Essentials database on a remote system by
providing the IP address or host name and the database instance name of the remote system in Database Server.
NOTE: If you select the Custom install option and do not enter any credentials, the installation is considered as a
typical installation and sysadmin rights are required.
NOTE: If you have multiple database instances running on a selected database server, you can specify the required
database instance name to configure the Essentials database with it. For example, using (local)\MyInstance, you
are configuring Essentials database on a local server and MyInstance named database instance.
NOTE: The parameters of all tasks that you create are encrypted and saved. During a reinstallation, if you choose to
use a database that was retained from a previous OpenManage Essentials installation, the existing tasks will not run
successfully. To resolve this issue, you must recreate all tasks after the installation.
NOTE: If you select the Custom install option, you can customize the database name. You can enter any name of
your choice in the Database Name field. If you do not enter a database name, by default, OMEssentials is selected.
Typically, you can use the database name field in a scenario where you have a dedicated remote SQL server that
you want to use for installing multiple OpenManage Essentials instances. For example, you can assign the database
name as DB_OME_Site1, DB_OME_Site2, and DB_OME_Site3 while installing the respective OpenManage
Essentials instances.
NOTE: The database name must start with an alphabet and it should not exceed 80 characters in length. You may
also include special characters in the database name, except square brackets ([]), apostrophe ('), and curly
brackets ({}).
4. Verify the installation settings in the Ready to Install the Program page and the click Install.
Setting Up OpenManage Essentials Database on a Remote SQL Server
You can configure OpenManage Essentials to use an SQL Server present on a remote system. Before setting up the OpenManage
Essentials database on the remote system, check for the following prerequisites:
• Network communication between the OpenManage Essentials system and the remote system is functioning.
• SQL connection works between the OpenManage Essentials system and the remote system for the specific database instance.
You can use the Microsoft SQL Server Express 2012 Management Studio tool to verify the connection. On the remote
database server, enable TCP/IP protocol and if you are using SQL Authentication, enable mixed mode on the remote SQL
Server.
You can retarget the database for the following:
• SQL credentials to the SQL Server fails.
• Windows credentials to the SQL Server fails.
• Login credentials have expired.
• Database is moved.
Retargeting the OpenManage Essentials Database
You can setup the OpenManage Essentials console to connect to an OpenManage Essentials database available on a remote
system. For example, after installing OpenManage Essentials with a local database, you can back up and restore the OpenManage
Essentials database on a remote system. After the database is restored on the remote system, you can setup OpenManage
Essentials to connect to the restored database available on the remote system.
The steps to retarget the OpenManage Essentials database are as follows:
1. Backup the OpenManage Essentials database
2. Restore the OpenManage Essentials database
26