Hi Karthikeyan,
Did you download and install to Informix ODBC drivers from the Tool page I linked?
Did you follow these steps as well?
Connecting to Unity Connection 7.x or Later
For installations of 7.0(1) and later you need to use the database proxy service for access to the database from off box for any tool that uses database access.
Task 1: Configure a User without a mailbox with the Remote Administrator and System Administrator roles
- •1. Go to the Cisco Unity Connection Administration web interface for your installation.
- •2. You can leverage a user with or without a mailbox for off box data access purposes, but it’s strongly suggested that you create a new user without a mailbox that is used solely for the purpose of remote administration tasks for security reasons. This is also required if you want to export messages from a Connection 7.0(2) or later server – a user with a mailbox may not be allowed to extract messages from other mailboxes, whereas a user without a mailbox should have no problem.
- •3. Be sure the web administration password for this user is not configured to require a change at first login on the “Password Policy” page for that user.
- •4. If necessary, change the web administration password on the “Change Password” page. Note that only the web application password comes into play for remote data access.
- •5. Finally, on the “Role” page for the user, add the “Remote Administrator” and the “System Administrator” roles to the “Assigned Roles” list and save. You can assign any or all other roles as well but for the purposes of remote access to the database and making updates to users those two are necessary.
Task 2: Set the Database Proxy Service Shutdown Time
Out of the box the database proxy service is not running and if you try to start the service it will shut down right away. First you need to set the “Database Proxy: Service Shutdown Timer” value found in the System Settings -> Advanced -> Connection Administration section of the Cisco Unity Connection Administration page. By default this is 0. You can set it to as high as 999 days if you like. After the number of days configured here the remote database proxy service will shut down. This is useful if you want to do some migration work, for instance, and don’t want to forget to have the service disabled for security reasons.
NOTE: If you restart the server, the remote database proxy service will remain shut off. After a system restart you have to go in and manually turn on the service again (see step 3)
Task 3: Activate the Remote Database Proxy Service
- •1. Out of the box the service that listens to remote database requests is not active, you must turn it on. To do this, go to the “Cisco Unity Connection Serviceability” web admin page.
- •2. On the Tools menu, select the “Service Management” page.
- •3. The “Connection Database Proxy” item under the “Optional Services” section will be marked as “Deactivated” and stopped. Press the “Activate” button and it will be activated and started automatically.
Once you’ve started the proxy service you can connect with any tool that needs off box database access using the user name, web administration password and port “20532”.
NOTE: The service will automatically shut down after the number of days configured in step 2 above or if you restart the server.
Cheers!
Rob
"Why not help one another on the way" - Bob Marley
