05-14-2013 03:36 AM - edited 03-14-2019 11:43 AM
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
Solved! Go to Solution.
05-14-2013 06:26 AM
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.
05-14-2013 05:55 AM
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
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
05-14-2013 06:26 AM
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.
05-14-2013 07:26 PM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide