« Back to Contact Center Express Scripting Questions

Facing issue with external database connection in uccx 8

Combination View Flat View Tree View
Threads [ Previous | Next ]
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.
 

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

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?