Reports Integration Guide › Deployment › CA Business Intelligence › Install CA Business Intelligence › Create an Empty SQL Server Database

Create an Empty SQL Server Database

Although the CA Business Intelligence installer allows you to create a SQL Anywhere database, we do not recommend this option for a production system.

We recommend that CA Business Intelligence uses an existing database for the BusinessObjects repository. If you choose this option, you must create the database before running the CA Business Intelligence installer. This section briefly describes how to create a SQL Server 2008 database.

To create an empty SQL Server database

1. In SQL Server Management Studio, add a new login (for example, BOUSER).

   This login will be the owner of the new database. It must use SQL Server Authentication.

2. Create a new database (for example, BOREPOS).

   The owner of this database must be the new login (BOUSER in this example). We recommend that you also reset the initial database size and enable autogrowth.

   Note: For performance reasons, create this BusinessObjects database on a different server server from your CA Data Protection CMS database.