Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011

    Unanswered: Change the CMS Database

    Has anyone changed the Crystal Reports Central Manangement Console (CMC) data source to another with a different database name, on a different database host?
    Last edited by db808; 05-06-11 at 19:17.

  2. #2
    Join Date
    Apr 2011


    Oh Well.. I solved it and here's the steps in case anyone needs it.
    FYI, my Old Database was Oracle 10g on AIX and the new server was Oracle 10g on Windows 2003

    - Export the "Crystal" schema from the source database
    - Create the "Crystal" user, in the target database, with with DBA & Resource rights
    - Import the "Crystal" Schema into target database
    - On the target server, start the Central Configuration Manager (CCM) and stop all of the services
    - Right Click on the Server Intelligence Agent and select Properties
    - Choose the Configuration tab
    - Click “Specify” button to change the CMS database
    - Select the Connection Method, then the login credentials. For Oracle, enter in the DB Service name as the Server Name.

    - Next change the Auditing Database Configuration, by clicking on the “Specify” button (next to the existing server name).
    - Select the Connection Method, then the login credentials. Enter in the Database Server Name as the Server Name

    - Restart all of the services
    - Start up the Central Management Console (CMC), select Settings, and you should now see your new database location

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts