Switch Between Databases in AD Bridge

To send events to a different database, you must change the database connection string in at least two places:

  • The reaper service for the database (BTEventDBReaper)
  • The Enterprise Database Management page in the BeyondTrust Management Console.

Changing the setting on the Enterprise Database Management page automatically changes the same setting on the console's Audit and Access Reporting page and the Operations Dashboard.

However, if you installed different plug-ins of the BeyondTrust Management Console on different computers - to run the Operations Dashboard on a separate computer, for example, then you must change the database connection string on each computer. You may also have to change it in the following additional locations, especially if the computer's AD Bridge Console does not include the Enterprise Database Management plug-in: the Audit and Access Reporting page and the Operations Dashboard page.

After making the changes, you must reset the reaper service so it begins sending events to the new database.

Reporting Database Connection

  1. In the AD Bridge Console tree on your Windows administrative workstation, right-click the Enterprise Database Management node and then click Connect to database.
    • Click Change. Under Database Type, select Microsoft SQL Server, and then enter the name of the database server instance in the Server/Instance box.
    • Enter the credentials of the database definer account if required for the authentication type that you selected, and then click OK.

 

  1. In the console tree, right-click the Operations Dashboard node and then click Connect to.
    • Click Change.
    • Change the database settings as needed, and then click OK.
  2. In the console tree, right-click the Audit and Access Reporting node, and then click Advanced.
    • Click Change.
    • Change the database settings as needed, and then click OK.
  3. Open a command prompt window as an administrator and then change directories to C:\Program Files\BeyondTrust\PBIS\Enterprise\DBUtilities, and then run the following command: 
    BTEventDBReaper /gui
    Make the changes that you want, and then click OK.
  4. Reset the BTEventDBReaper to 0 and then refresh its settings to prompt it to send the events to the new database. To do so, from the C:\Program Files\BeyondTrust\PBIS\Enterprise\DBUtilities folder, run the following commands as an administrator: 
    BTEventDBReaper /f 0
BTEventDBReaper /r