You can create the SQL databases in either All Databases mode or Single Database mode.
- A data directory must be created on the remote SQL Server for the database files.
- You must have access to a user account that has permissions to create databases on the remote SQL Server. You must either login as a trusted user that has admin privileges or have the Username and Password for an authorized SQL Server login with admin privileges.
Creating the databases using All Databases mode
Use this procedure to install your databases in All Databases mode.
Perform this task on the server that hosts the Portal.
- Run the following program from the Windows™ Start menu: Start > All Programs > TeaLeaf Technology > Tealeaf CX Report Server > CX Report Database Manager
- Enter your connection information.
- In the menu, select Mode > Database Setup > All Databases.
- From the Action drop-down, select
Install
. - Select other options as needed.
- Click OK.
Note: After you have begun installation or upgrading in All Database Mode, canceling interrupts the process after the requested action has been completed on the current database. The actions on the current database and all previous databases are retained, and any remaining databases are left untouched. You may wish to revert to the backup or make adjustments before completing the action.
- After the operation completes, review the output window.
Be sure to review the Failed Statements pane to verify that all statements were successfully executed.
- After you create the databases, you must initialize them.
Creating the Databases using Single Database mode
Use this procedure to install your databases in Single Database mode.
Perform this procedure on the server that hosts the Portal. Tealeaf databases must be installed in the following order:
- Create the System database.
- Create the Reports database.
- Configure the System database. If you install or update the System database, you must install or re-install the event definitions through the Tealeaf Database Manager at some later point in the install process.
- Create or update other databases in any order.
- Run the following program from the Windows Start menu: Start > All Programs > TeaLeaf Technology > Tealeaf CX Report Server > CX Report Database Manager
- Enter your connection information.
- Install the System database.
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
System
. - From the Action drop-down, select
Create
. - Click OK.
- After the operation completes, review the output window.
In the Failed Statements pane, verify that all statements ran successfully.Note: If you install or update the System database, you must install or re-install the event definitions through the Tealeaf Database Manager at some later point in the install process.
- Close the output window.
- Install the Reports database.
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
Reports
. - From the Action drop-down, select
Create
. - Click OK.
- After the operation completes, review the output window.
In the Failed Statements pane, verify that all statements ran successfully.
- Close the output window.
- Configure the System database:
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
System
. - From the Action drop-down, select
Upgrade
. - For the Command File, navigate to
<Tealeaf_Install_Directory>\Reporting\DatabaseSchema\SystemDBConfig.xml
. - Click OK.
- After the operation completes, review the output window.
In the Failed Statements pane, verify that all statements ran successfully.
- Close the output window.
- Initialize the database:
- In the menu, select Mode > Data Management > Initialize Configuration.
- Click OK.
- After the operation completes, review the output window.
In the Failed Statements pane, verify that all statements ran successfully.
- Close the output window.
- Install the RS Extractor database:
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
RS Extractor
. - From the Action drop-down, select
Create
. - Click OK.
- After the operation completes, review the output window.
In the Failed Statements pane, verify that all statements ran successfully.
- Close the output window.
- Install the Statistics database:
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
Statistics
. - From the Action drop-down, select
Create
. - Click OK.
- After the operation completes, review the output window.
In the Failed Statements pane, verify that all statements ran successfully.
- Close the output window.
- Install the Tealeaf cxReveal database:
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
Search
. - From the Action drop-down, select
Create
. - Click OK.
- Close the output window.
- After you have created the System database or installed all databases one at a time, you must initialize them.
After you completed your installation, specify a backup strategy, recovery model, and log file compression settings.