Installation Guide › Server Installation › Report Server › High Availability Report Server on PostgreSQL › Configure the SQL Anywhere Client to Connect to the Remote Database

Configure the SQL Anywhere Client to Connect to the Remote Database

Perform these steps on the Report Server system.

Follow these steps:

1. Download and Install SQL Anywhere Client (32 bit).
2. Set the environment of SQL Anywhere:

   cd $Installation_Dir/bin32/
   source sa_config.sh
   

3. To connect and verify that the CMS DSN is accessible:

   ./dbping -c "UID=$BOE_CMS_UID;PWD=$BOE_CMS_PWD;SERVER=$SQLANYWHERE_SERVER;LINKS=TCPIP(HOST=$SQLANYWHERE_HOST;PORT=$SQLANYWHERE_PORT)"
   

4. To create CMS Data Source:

   ./dbdsn -w $CMSDataSource -c "UID=$BOE_CMS_UID;PWD=$BOE_CMS_PWD;SERVER=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;dbn=cms"
   

5. To connect and verify that the AUDIT DSN is accessible:

   ./dbping -c "UID=$BOE_AUDIT_UID;PWD=$BOE_AUDIT_PWD;SERVER=$SQLANYWHERE_SERVER;LINKS=TCPIP(HOST=$SQLANYWHERE_HOST;PORT=$SQLANYWHERE_PORT)"
   

6. Create the audit DSN:

   ./dbdsn -w "AuditDataSource" -c "UID=$BOE_AUDIT_UID;PWD=$BOE_AUDIT_PWD;SERVER=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;dbn=cms"