Knowledge Center

This article describes the recommended procedure for moving the ePO database from one SQL Server to another.

IMPORTANT: Before you begin the process explained in this article, you must back up your ePO server. See KB87976 for details of the Disaster Recovery Snapshot process, and KB66616 for details of the manual backup procedure.

NOTE: The account used by ePO to access SQL must have the minimum required permissions on the new server for ePO to function correctly. See KB75766 for details.

Overview
To move the ePO database, follow the steps below in the order they are listed:

• Stop ePO services
• Move the database
• Configure ePO and verify connectivity
• Start ePO services
• Extra steps for additional Agent Handlers
• Optional: Remove service dependencies

Stop ePO services
Before making any changes, you must stop ePO services to prevent anything from accessing the database:

1. Click Start, Run, type services.msc, and click OK.
2. Right-click the following services and select Stop:
   
   On the ePO server:

   

Move the database

1. On the current SQL Server, take a full backup of the ePO database using SQL Management Studio. If you are unfamiliar with this process, see KB52126.
   
   When complete, you have a backup (.BAK) file.
    
2. Copy the .BAK file to the new SQL Server.
3. Restore the backup file to the new server using SQL Management Studio. See KB52126 for this process, if needed.
   
   After the restore completes, the ePO database is visible in Management Studio on the new SQL Server.

Configure ePO and verify connectivity

1. On the ePO server only, start the McAfee ePolicy Orchestrator Application Server service.
2. Open a web browser and navigate to the "core/config-auth" database configuration page https://localhost:8443/core/config-auth by default.
   
   NOTE: If needed, adjust the host name and port to match your custom configuration.
    
3. When the logon prompt displays, log on using an ePO Global Administrator account.
   
   The "Configure Database Settings" page displays.
    
4. Type the details for the new SQL Server.
5. Click Test Connection.
   
   "The database connection was tested successfully" message displays.
   
   If any errors display, verify and correct the new SQL Server details until the connection test succeeds.
    
6. When the connection test is successful, click Apply.
   
   A prompt to restart the server displays.
    
7. Restart the McAfee ePolicy Orchestrator Application Server service.

Start ePO services

1. Click Start, Run, type services.msc, and click OK. 
2. Right-click the following services and click Start:
   
   On the ePO server:
   
   McAfee ePolicy Orchestrator Event Parser
   McAfee ePolicy Orchestrator Server

Extra steps for additional Agent Handlers
If you have additional Agent Handlers, each one must be provided with the new SQL Server details by rerunning the initial setup wizard. Perform the following steps on each Agent Handler:

1. Press Windows Key + X and select Programs and Features.
2. Select McAfee Agent Handler and click Change.
   
   The McAfee Agent Handler InstallShield wizard displays.
    
3. Click Next, click Modify, and then click Next again.
4. Type the details for the ePO server and click Next.
   
   The Database Information page displays.
   
   NOTE: The Database Server field should already contain the name of the new SQL Server. If it does not, correct the name.
    
5. Type the new SQL Server connection credentials.
   
   NOTE: The Database Name field should already contain the correct database name. If it does not, correct the database name.
    
6. Click Next, then click Install.
   
   The Agent Handler is now reconfigured to use the new SQL Server.

The database migration is complete, and ePO now uses the new SQL Server.

You can safely delete the database copy from the old server if your organization requires it, or if you need to free up disc space on the old server.


Optional: Remove service dependencies
IMPORTANT: You need to perform this step only if the ePO database was previously hosted on the ePO server itself, meaning SQL Server was installed on the ePO server computer alongside ePO. If you moved the database from one remote SQL Server to another, you can safely ignore this step.

If the ePO database was hosted on the ePO server, ePO services have dependencies on the SQL Server services. These dependencies mean that you are unable to stop the SQL services or uninstall SQL without affecting ePO. You must remove the dependencies from the services by editing the registry:

CAUTION: This article contains information about opening or modifying the registry.

• The following information is intended for System Administrators. Registry modifications are irreversible and could cause system failure if done incorrectly.
• Before proceeding, Technical Support strongly recommends that you back up your registry and understand the restore process. For more information, see: http://support.microsoft.com/kb/256986.
• Do not run a REG file that is not confirmed to be a genuine registry import file.

1. Click Start, Run, type regedit, and click OK.
2. Navigate to each of the following registry keys and remove the dependencies using the following steps:
   
   HKEY_LOCAL_MACHINE\SYSTEM\Current ControlSet\Services\MCAFEEAPACHESRV
   HKEY_LOCAL_MACHINE\SYSTEM\Current ControlSet\Services\MCAFEEEVENTPARSERSRV
   HKEY_LOCAL_MACHINE\SYSTEM\Current ControlSet\Services\MCAFEETOMCATSRVXXX
   
   (where XXX is the version of ePO)
    
   1. Double-click the DependOnService value.
   2. From the value data, delete the line reading MSSQLServer.
   3. Click OK.
       
3. Restart the ePO Server computer.
   
   NOTE: It is not mandatory to restart, but the old dependency settings remain in effect until a restart completes. If you cannot restart the ePO Server computer now, plan for a restart as soon as possible.