Previous Topic: Install CA Business IntelligenceNext Topic: Create DSN and ODBC Connection

Install the Components › Install CA Business Intelligence › Create CA Business Intelligence Database

Create CA Business Intelligence Database

You can create a Microsoft SQL database before installing CA Business Intelligence.

If MS SQL is installed on a different server, perform the following procedure on that server. However, since the MS SQL Client Tools are installed on the CA Business Intelligence server, it is recommended that you performed the steps remotely. Thus validates the SQL connectivity between the two servers.

Follow these steps:

  1. Log in to the server where you want to install CA Business Intelligence.
  2. Open Microsoft SQL Server Management Studio.
  3. Log in using a SQL Administrator account (for example, sa).

    The Microsoft SQL page opens.

    CA Business Intelligence MS SQL

  4. Right-click Databases and select New Database.

    The New Database dialog opens.

    CA Business Intelligence New Database

  5. Click General in the Select a page panel.

    The General dialog opens.

  6. Enter a Database name (for example, BOXI) and click OK.

    Note: Update your Installation Worksheet with the installation values. You need this information for subsequent installations.

    You have created the CA Business Intelligence database in Microsoft SQL.