Create the LikewiseEnterprise Database

You can create the database using the Reporting Database Connection Manager or using SQL Server.

Use the Reporting Database Connection Manager

Use the Reporting Database Connection Manager to create the database. The manager is installed with the ADBridgeDBUtilities-*.exe installer.

  1. From the Start menu, go to BeyondTrust > AD Bridge, and select Reporting Database Connection Manager.

AD Bridge reporting database connection dialog box

  1. Select Enable BeyondTrust AD Bridge Reporting.

 

  1. Select the SQL Server instance from the list.
  2. Select the authentication method. If you select SQL Server, then enter the credentials.
  3. Enter the timeout value.
  4. Click Create Database.
  5. Click Test Connection to ensure proper access to the SQL Server instance.

Use SQL Server

In earlier versions of AD Bridge, BeyondTrust provided certain files on the ISO image. In AD Bridge version 10.0 and later, an ISO image is no longer created.The CreateLikewiseEnterpriseDatabase.sql script is now installed with the ADBridgeDBUtilities* package and is located in:
C:\Program Files\BeyondTrust\PBIS\Enterprise\DBUtilities\Resources

To create the AD Bridge Enterprise Reporting Database using SQL Server:

  1. Start Microsoft SQL Server Management Studio and connect to the database engine.
  2. Create a database named LikewiseEnterprise.
  3. Copy the SQL Server database creation script to a location accessible from SQL Server:
  4. CreateLikewiseEnterpriseDatabase.sql
  5. In SQL Server Management Studio, on the File menu, click Open and load the AD Bridge Enterprise database creation script:
  6. CreateLikewiseEnterpriseDatabase.sql
  1. Connect to the LikewiseEnterprise database, and run the script. If the script executes with errors, run the script again.