CRServer 2013 - how to re-direct audit/config database to another dbserver

[Former Member]

Hi: I am building a Crystal Reports Server 2013.  During installation, I took the defaults and directed

the system and auditing database to Sybase SQL Anywhere.

I now wish to direct the stuff to another database server.

It talks about about re-configuration in various admin docs and auditor docs,

however the instructions do not work for CRServer 2013.

Any one, know how this can be done?

                                 thanks, Stanley Kita

[DellSC]

What type of database are you going to put it into?  Whatever the database, you need to have the db client software installed on the report server.  If it's SQL Server, you need to create a System ODBC DSN before you can proceed.  If it's Oracle, you need to have a TNSNames that provides aliases for both database schemas.

System Database:

1.  Open the Central Configuration Manager.

2.  Stop the SIA.

3.  Open the properties of the SIA.

4.  Go to the Configuration tab.

5.  Click on the Specify button.

6.  Select "Copy from another data source"

7.  Under "Get Data From" specify the Sybase SQL Anywhere database.

8.  Under "Copy to the Following Datasource" specify the database you're moving to.

9.  Run the copy.

Audit database:

1.  You will probably not be able to move over any of the existing audit data.

2.  Log in to the Central Management Console.

3.  Select "Auditing"

4.  Scroll down to "ADS Database" under "Configuration".

5.  Select the database type.

6.  Enter the database name and credentials.

7.  Save.  I believe this will then create the audit tables in the new database.

-Dell