The process of configuring the data warehouse for Rational® Common Reporting depends on the relational database management
system being used to host the data warehouse.
About this task
Configuring the DB2 data warehouse If you chose to manually run scripts when you
installed the data warehouse server, additional steps are needed to
configure the data warehouse. Make sure that the batch files for setting
up the data warehouse are run successfully.
Configuring the Microsoft SQL Server data warehouse If you chose to not automatically run scripts
when you installed the data warehouse server, additional steps are
needed to configure the data warehouse. By default, Windows® authentication is used for the Microsoft® SQL Server instance
and database. Therefore, you need to ensure that the users of the
report server connecting to the database and executing queries are
valid Windows users of the
data warehouse server. Also, you need to ensure that the batch files
for setting up the data warehouse run successfully.