Setting up Sql Server as the Report Server Repository

Products

• Cleverpath Reporter
• EUREKA:Reporter
• EUREKA:Strategy

Issue/Introduction

---

This document describes how to install the Computer Associates CleverPath Report Server using the Microsoft Sql Server 7.0 or Sql 2000 database as the repository, and how to properly prepare the database.

 

Environment

Release:
Component: PORTAL

Resolution

Setting up Sql Server as the Report Server Repository

1. Create a new database.
   
   1. In Enterprise Manager single right click on "Databases" and select "New Database", or click on the "New Database" button in the tool bar.
      
      
   2. You can name this database anything you want. Reporter7 is used as an example.
   3. Leave "Automatically grow file" selected. Also leave the default of "By percent" and "unrestricted filegrowth" selected.
   4. Click "OK"

    

2. Create a new login.
   
   1. With your new database selected (highlighted), click on the "New Login" button in the toolbar.
      
      
   2. In the first dialog box [General], name this login. We use reporterdba as an example only. You can use whatever name you choose for the login
      

       

   3. Select "Sql Server Authentication" and type the password. Again, reporterdba is used as an example only, you can use whatever password you choose.
   4. Under the "Defaults" section, select the database you just created - "Reporter7" in this example - as the default database
   5. Now select the "Database Access" tab at the top of the dialog box. Here is where you select the database this login has access to. Select the database you just created - again, "Reporter7" in this example - as the database this login has access to.
      

       

      Once you select the database to access you will be presented with choices for "Database roles for 'Reporter7'" By default, "public" is the only thing selected. That's the only thing that needs to be selected, do not check anything else.
   6. Click "OK"

 

1. Grant Permissions to the database.
   
   1. Single right click on your newly created database - and select "Properties".
   2. In the dialog box, select the "Permissions" tab at the top.
   3. Place a check in each box for both the "Public" user and the "reporterdba" user.
      

       

   4. Click "Apply" and then "OK".

Sql Server is now set up properly for use as the Report Server Repository.

You are now ready to install the Computer Associates CleverPath Eureka Report Server.