Facing issue with external database connection in uccx 8

Version 1

    Subject: RE: Facing issue with external database connection in uccx 8
    Replied by: Steven Pawlak on 28-05-2012 09:51:08 AM
    The beginning of the string is wrong and you are not passing enough data as well.

    jdbc:jtds:sqlserver://192.168.20.72:1433/master;Instance=<insert Instance name here>

    You might also have to pass DomainName. All other additions go on as ";" separated property=value pairs at the end.


    There is also this
    https://supportforums.cisco.com/thread/2113632
    This document was generated from CDN thread

    Created by: Raja Raman veerappan on 28-05-2012 07:31:12 AM
    I tried to connect with microsoft sql server database from uccx admin
     
    i used the following data source configuration
     
    Data source name: sqlconnection
    username:sa
    driver:net.sourceforge.jtds.jdbc.Driver.        From the zip file  jtds-1.2.5-dist.zip
    jdbcurl:jdbc:jtds:sqlserver://192.168.20.72:1433/master
     
    when trying to connect it is showing test connection failed
     
    I even tried using dbvisvualizer to connect with the database. here connection can be established but no so in uccx(8.0.2)
     
    please help me to solve this issue.
     

    Subject: RE: Facing issue with external database connection in uccx 8
    Replied by: Raja Raman veerappan on 30-05-2012 06:28:41 AM
    The beginning of the string is wrong and you are not passing enough data as well.

    jdbc:jtds:sqlserver://192.168.20.72:1433/master;Instance=<insert Instance name here>

    You might also have to pass DomainName. All other additions go on as ";" separated property=value pairs at the end.


    There is also this
    https://supportforums.cisco.com/thread/2113632



    Hai Steven,
     
     
    I tried using the domainname along with the url but still i am getting  the same test connection fialed error,
     
    I used this url now.
    jdbc:jtds:sqlserver://192.168.20.72:1433/databasename=master;domain=PWCAW1.cuicm.com
     
    and I checked  with both sql and windows credentials.
     
    I need to ask you one more question
     
    The database I am trying to connect is ICM admin workstation database which is in server 192.168.20.25 (admin workstation instance IP is 192.168.20.72). uccx is installed in 192.168.20.24 (uccx instance IP is 192.168.20.17).
     
    Is it possible to connect with database of ICM components?