Installing databases without full SQL Server permissions

You can install Acoustic Experience Analytics (Tealeaf) databases as the TLADMIN user or as a customer user with the same permissions.

1. Before running the Database Manager, someone with SA access must run the database creation scripts for any new databases. These scripts create the empty databases and users on SQL Server and are provided in the following directory:

   
   <Acoustic Experience Analytics (Tealeaf)_install_directory>\SQL\DBCreateScripts 
   

2. Start the Database Manager:

   
   <Acoustic Experience Analytics (Tealeaf)_install_directory>\Reporting\TealeafDatabaseManager.exe
   

3. In the Connection window, verify that the correct host and port values are entered. You must connect using Experience Analytics authentication.
4. Click Connect.
5. Complete one of the following sequences, depending on how you are installing the databases.
   Note: When installing or upgrading in Experience Analytics authentication mode, some individual commands might fail. You can ignore the failure messages if the Database Manager reports a successful installation or upgrade.
   1. All Databases Mode Install/Upgrade:
      1. In the menu, select Mode > Database Setup > All Databases.
      2. In the Action drop-down, select Install for an installation.
      3. In the DB Creation menu, clear Create Databases, which prevents Database Manager from attempting to create the databases or users and from attempting to grant permissions to these users on SQL Server.
      4. Click OK.
      5. After the operation completes, review the output window. In the Failed Statements pane, verify that all statements ran successfully.
      6. Close the output window.
   2. Single Database Mode Install/Upgrade:
      1. In the menu, select Mode > Database Setup > Single Database.
      2. Select the Action and Database Type, and set any necessary options.
      3. In the DB Creation menu, deselect Create Databases, which prevents the Database Manager from attempting to create the databases or users and from attempting to grant permissions to these users on SQL Server.
      4. Click OK.
      5. After the operation completes, review the output window. In the Failed Statements pane, verify that all statements ran successfully.
      6. Close the output window.
6. Post-Install/Upgrade Steps:
   1. In the menu, select Mode > Database Users > Permissions Scripts.
   2. In the Output Location field, enter the location and file name where you want to store the output scripts.
   3. Click OK. An SQL script containing all of the necessary permission grant statements is generated in the output location.
   4. Access the scripts in the directory you selected.
   5. Have the DBA or person with SA access run the scripts.
7. Acoustic Experience Analytics (Tealeaf) Authentication: If you are running these steps using Experience Analytics authentication, you must perform the following steps now to configure the System database:
   1. In the menu, select Mode > Database Setup > Single Database.
   2. From the Database drop-down, select System.
   3. From the Action drop-down, select Upgrade.
   4. For the Command File, navigate to the following directory:

      
      <Tealeaf_Install_Directory>\Reporting\DatabaseSchema\
      

      1. Depending on the products you licensed, the following files appear in the directory. You must run each of the following schema upgrades for the databases of the products you installed.
         1. Experience Analytics CX: SystemDBConfig.xml
         2. Experience Analytics cxReveal: RevealDBConfig.xml
   5. Click OK.
   6. After the operation completes, review the output window. In the Failed Statements pane, verify that all statements ran successfully.