#1 2021-06-16 11:41:24

karim
Member
Registered: 2021-06-16

The connection TEST Failed: JDBC SQL SERVER

HI,

i can't connect to my DATABASE with JDBC:

- DRIVER in LIB sqljdbc41.jar and sqljdbc42.jar => OK

i put DRIVER JDBC in:

*C:\Bitnami\reportserver-3.7.0.6044-0\apache-tomcat\lib
*C:\Bitnami\reportserver-3.7.0.6044-0\apps\reportserver\reportserver-conf\lib
*C:\Bitnami\reportserver-3.7.0.6044-0\apache-tomcat\webapps\reportserver\WEB-INF\lib

in My SQL SERVER2014 CONFIGURATION PROTOCOL TCPIP ==> OK

i have this error message:

**Error
Could not open connection to: jdbc:sqlserver://PPNETSERVERPIC1:1433;databaseName=ProPlusNetV2 with user: sa. com.microsoft.sqlserver.jdbc.SQLServerException: Le pilote n'a pas pu établir de connexion sécurisée au serveur SQL Server à l'aide du chiffrement SSL (Secure Sockets Layer). Erreur : « The server sel
**display error details

net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: jdbc:sqlserver://PPNETSERVERPIC1:1433;databaseName=ProPlusNetV2 with user: sa. com.microsoft.sqlserver.jdbc.SQLServerException: Le pilote n'a pas pu établir de connexion sécurisée au serveur SQL Server à l'aide du chiffrement SSL (Secure Sockets Layer). Erreur : « The server sel
<br>    at net.datenwerke.rs.base.service.datasources.transformers.database.Database2TableTransformer.transform(Database2TableTransformer.java:57)
<br>    at net.datenwerke.rs.base.service.datasources.transformers.database.Database2TableTransformer.transform(Database2TableTransformer.java:1)
<br>    at net.datenwerke.rs.base.service.datasources.transformers.DatasourceTransformationServiceImpl.transform(DatasourceTransformationServiceImpl.java:29)
<br>    at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:141)
<br>    at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:132)
<br>    at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:119)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl.testConnection(DatasourceTesterRPCServiceImpl.java:104)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802.CGLIB$testConnection$0(&lt;generated&gt;)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802$$FastClassByGuice$$18d446b2.invoke(&lt;generated&gt;)
<br>    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76)
<br>    at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802.testConnection(&lt;generated&gt;)
<br>    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
<br>    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
<br>    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
<br>    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
<br>    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802.CGLIB$processCall$3(&lt;generated&gt;)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802$$FastClassByGuice$$18d446b2.invoke(&lt;generated&gt;)
<br>    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802.processCall(&lt;generated&gt;)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802.CGLIB$processCall$4(&lt;generated&gt;)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802$$FastClassByGuice$$18d446b2.invoke(&lt;generated&gt;)
<br>    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802.processCall(&lt;generated&gt;)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
<br>    at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802.CGLIB$service$16(&lt;generated&gt;)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802$$FastClassByGuice$$18d446b2.invoke(&lt;generated&gt;)
<br>    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
<br>    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54)
<br>    at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$2958c802.service(&lt;generated&gt;)
<br>    at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)
<br>    at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)
<br>    at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)
<br>    at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)
<br>    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85)
<br>    at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:94)
<br>    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82)
<br>    at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121)
<br>    at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133)
<br>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
<br>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
<br>    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
<br>    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
<br>    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
<br>    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
<br>    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
<br>    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
<br>    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
<br>    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
<br>    at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433)
<br>    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
<br>    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
<br>    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
<br>    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
<br>    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
<br>    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
<br>    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
<br>    at java.base/java.lang.Thread.run(Thread.java:829)
<br>Caused by: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Le pilote n&#39;a pas pu établir de connexion sécurisée au serveur SQL Server à l&#39;aide du chiffrement SSL (Secure Sockets Layer). Erreur : « The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12] ». ClientConnectionId:dec100d7-ea89-4868-a7d2-a21d4df549fb
<br>    at net.datenwerke.dbpool.DbC3p0PoolServiceImpl$1.get(DbC3p0PoolServiceImpl.java:189)
<br>    at net.datenwerke.dbpool.DbC3p0PoolServiceImpl$1.get(DbC3p0PoolServiceImpl.java:1)
<br>    at net.datenwerke.rs.base.service.datasources.transformers.database.Database2TableTransformer.transform(Database2TableTransformer.java:54)
<br>    ... 87 more
<br>Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Le pilote n&#39;a pas pu établir de connexion sécurisée au serveur SQL Server à l&#39;aide du chiffrement SSL (Secure Sockets Layer). Erreur : « The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12] ». ClientConnectionId:dec100d7-ea89-4868-a7d2-a21d4df549fb
<br>    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2826)
<br>    at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1829)
<br>    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2391)
<br>    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2042)
<br>    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1889)
<br>    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1120)
<br>    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:700)
<br>    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
<br>    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
<br>    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:211)
<br>    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1127)
<br>    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1114)
<br>    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
<br>    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1855)
<br>    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
<br>Caused by: javax.net.ssl.SSLHandshakeException: The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]
<br>    at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
<br>    at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:117)
<br>    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:336)
<br>    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:292)
<br>    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:283)
<br>    at java.base/sun.security.ssl.ServerHello$ServerHelloConsumer.onServerHello(ServerHello.java:956)
<br>    at java.base/sun.security.ssl.ServerHello$ServerHelloConsumer.consume(ServerHello.java:878)
<br>    at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:392)
<br>    at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:443)
<br>    at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:421)
<br>    at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:182)
<br>    at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:171)
<br>    at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1418)
<br>    at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1324)
<br>    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:440)
<br>    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:411)
<br>    at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1756)
<br>    ... 13 more
<br>

Offline

#2 2021-06-23 06:43:00

eduardo
Administrator
Registered: 2016-11-01
Website

Re: The connection TEST Failed: JDBC SQL SERVER

Hi karim,

can you pls try with a new MSSQL driver ? the one you are using seems to be old.

Also, you can delete it from these locations:

*C:\Bitnami\reportserver-3.7.0.6044-0\apache-tomcat\lib
*C:\Bitnami\reportserver-3.7.0.6044-0\apache-tomcat\webapps\reportserver\WEB-INF\lib

and leave it only here:
*C:\Bitnami\reportserver-3.7.0.6044-0\apps\reportserver\reportserver-conf\lib

Regards,
Eduardo

Online

#3 2021-06-23 06:43:49

eduardo
Administrator
Registered: 2016-11-01
Website

Re: The connection TEST Failed: JDBC SQL SERVER

Hi karim,

also, pls leave only one driver, you seem to have two drivers:
sqljdbc41.jar and sqljdbc42.jar

Regards,
Eduardo

Online

Board footer

Powered by FluxBB