VMware Horizon Community
jsipes
Contributor
Contributor

JDBC driver error

I'm getting the following error when I try to define a database for events. for Horizion Veiw 7.6.0 build-9823717.

I opened a case with support and there recommending upgrading to JDBC driver from Microsoft (7.0).

This dos not feel right, if the driver is the problem there should be and update/fix or problem ID.

sqljdbc42-4.2.6420.100.jar is part of the VMware-Horizon-Connection-Server-x86_64-7.6.0-9823717.exe install package.

Has anyone else had problems with this? 

2018-11-27T14:11:53.611-07:00 ERROR (0FB8-16E0) <ajp-nio-8009-exec-10> [ConfigurationManagerBean] ADAM Error code: 2,128 com.vmware.vdi.logger.Logger.error(Logger.java:92)

com.vmware.vdi.adamwrapper.exceptions.ADAMServerException: database initialization failed, SQL exception when connecting to database: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.security.cert.CertificateException: Certificates do not conform to algorithm constraints". ClientConnectionId:17b8769e-3f6c-4d5c-a752-bbbb9ea01f04

at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1787)

at com.vmware.vdi.admin.be.ConfigurationManager.updateDatabaseConfiguration(SourceFile:1662)

at com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:177)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessor

Tags (2)
Reply
0 Kudos
2 Replies
techguy129
Expert
Expert

Do you have SSL enabled and/or enforced on connections to the SQL instances? jdbc will try to connect using SSL if its enabled. Based on the error, the database server isn't serving a supporting certificate.

Reply
0 Kudos
Tina07
VMware Employee
VMware Employee

Reply
0 Kudos