UCCX 11.5: Datasource Test Connection Failed

[Joseph Innis]

I am trying to connect a datasource in UCCX 11.5 to SQL 2014. I have successfully installed the jar file, but am having no luck with the JDBC URL. The SQL server that I am trying to connect to is currently working with a UCCE server, so I know its accepting connections. However, I'm not sure if the setup in SQL for UCCE is the same for UCCX. I have verified the following in SQL:

1. User account in that I am using in UCCX datasource is active

2. TCP/IP Client Protocols are placed above Named Pipes and are enabled

3. SQL server is listening on port 1433

4. Verified the database name is listed in the connection properties in the table that I am trying to access

5. Instance Name is blank

I've tried the following JDBC URLs:

jdbc.jtds.sqlserver://{host IP}:1433/{database name}

jdbc.jtds.sqlserver://{host IP}:1433/{database name};instance=

jdbc.jtds.sqlserver://{host IP}:1433/{database name};instance=MSSQLSERVER

jdbc.jtds.sqlserver://{host IP}:1433/{database name};instanceName=

jdbc.jtds.sqlserver://{host IP}:1433/{database name};instanceName=MSSQLSERVER

jdbc.jtds.sqlserver://{host IP}:1433/{database name};{domain}

jdbc.jtds.sqlserver://{host IP}:1433/{database name};instance=MSSQLSERVER;{domain}

jdbc.jtds.sqlserver://{host IP}:1433/{database name};instanceName=MSSQLSERVER;{domain}

...and I've probably tried a handful more, but you get the picture.

What I'm looking for is the correct JDBC URL to use and whether there are logs I can pull to determine where the issue is. I'm happy to pull any logs and post here if someone can tell me which logs to pull.

Thanks in advance

[Joseph Innis · Accepted solution]

RESOLVED.

On a whim, removed the port from the URL and it worked like a charm:

jdbc.jtds.sqlserver://{host IP}/{database name}

Test connection successful.

[Anwar khan]

Hi,

we have to give JDBC url as below format to avoid test connection fail right.

jdbc.jtds.sqlserver://10.32.132.61/UCCXDB

still I am getting Test Connection fail

Host IP is nothing but SQLserver PC IP ?

and is this IP should be added to DNS ?

your response will be highly appreciated

Thanks in advanced

Regards,

Anwar

[LIGIA VIDAL PEIXOTO]

My Windows Server / SQL is just like windows authenticator, using the query below always fails and in sql I see it trying as sql authenticator.

jdbc:jtds:sqlserver://<IP-ADDRESS>:1433/InstanceA/<dbname>;domain=<Business>;userNT LMv2=true

SQL Server Logs:
04/23/2019 01:33:04,Logon,Unknown,Login failed for user 'xyz'. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only. [CLIENT: X.X.X.X]

Has anyone had this problem?