Cannot add SQL2008 datasource to uccx?

[samhopealpha]

Hi everybody,

I tried to add a datasource to UCCX, but it returns "Test Connection failed"

Here is the environment:

- CUCM8.6

- UCCX8.5

- jtds1.5 driver added

- SQL2008 Express

host: 10.10.10.79/SQLEXPRESS

database: mydb2

Login: sa

password: P@ssw0rd

JDBC URL:

jdbc:jtds:sqlserver://10.10.10.79:1433/mydb2;instance=SQLEXPRESS;user=sa;password=P@ssw0rd

Anybody know what I missing or anything wrong in here ?

Thanks in advance

Sam

[Leo Salcie Tejeda]

Hi Sam,

UCCX 8.5 supports the following driver class for SQL server 2008,

net.sourceforge.jtds.jdbc.Driver.

The latest JTDS driver can be downloaded from:

http://sourceforge.net/projects/jtds/files/

The instructions to setup the database after installing the driver can be checked from page 441 of the link below

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_0/configuration/guide/uccx801ag.pdf

Please remember to rate useful posts clicking on the stars below.
Favor calificar todos las respuestas útiles dando click en las estrellas de mas abajo.
___________________________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie

[Gergely Szabo · Accepted solution]

Sam,

if there's a named instance in SQL Server - for a strange reason, SQL Express installs a named instance -, the listen port of the database server is assigned dynamically. Try specifying the JDBC URL without the port.

Also, you don't need to put the username and password information into the JDBC URL, as there is a separate field for it in UCCX (and putting the username and the password into the URL is not considered as safe).

G.

@leosalcie, the original poster DOES use JTDS. Please think before posting.

[samhopealpha]

Thanks Gergely, your indication is valuable to me!

I did follow your instruction, and found that the major problem is on MSSQL's dynamic listen port

Now I fixed it! thanks again