topic Re: SQL Server Extension failing to connect to server in Extensions

SQL Server Extension failing to connect to server

Troy — Tue, 24 Mar 2026 21:25:01 GMT

Using the Microsoft SQL Server extension we connected to several instances and was working flawlessly for quite some time,

Recently we are noticing 2012 servers are getting this error:

Cannot connect to database {server}\{instance}:{port}. Exception occurred: Can't create JDBC connection pool - "encrypt" property is set to "false" and "trustServerCertificate" property is set to "true" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: SQL Server did not return a response. The connection has been closed

This happened seemingly out of the blue - no changes made on our side or on the server itself. our config has the "Enable SSL" option disabled aswell.

Has anyone seen this error before and know the fix?

Re: SQL Server Extension failing to connect to server

AntonPineiro — Wed, 25 Mar 2026 10:14:11 GMT

Hi,

Have you turn on some SSL flag in extension? Is need it? Can be switch off?

Best regards

Re: SQL Server Extension failing to connect to server

Troy — Wed, 25 Mar 2026 13:38:06 GMT

The "Enable SSL" Toggle in the extension config is turned off already and we never turned it on.

Re: SQL Server Extension failing to connect to server

AntonPineiro — Wed, 25 Mar 2026 15:41:50 GMT

Hi,

I have just seen that error when SSL is enabled in extension and ActiveGate is not configured properly.

I would open a support ticket.

Best regards

Re: SQL Server Extension failing to connect to server

Troy — Thu, 26 Mar 2026 20:36:00 GMT

After a talk with support and rolling back an activegate as a test it seems to be an issue with Activegate version: 1.333.37 as rolling back solved the issue.

Re: SQL Server Extension failing to connect to server

AntonioSousa — Mon, 30 Mar 2026 15:51:57 GMT

I have one case I just diagnosed where "Enable SSL" is toggled off, but nonetheless, the extension is forcing a TLS connection. Confirmed it through a network dump. What I see is that the SQL Server (in this case SQL Server 2014) is terminating a tentative TLS connection immediately:

@Mike_L , might there be something in 1.333 that forces SSL/TLS connections, despite not being told to do so? Ticket #621565

Re: SQL Server Extension failing to connect to server

AntonPineiro — Tue, 31 Mar 2026 07:04:04 GMT

Hi,

Not sure if SQL Server 2014 is supported base on this list.

Best regards

Re: SQL Server Extension failing to connect to server

AntonioSousa — Tue, 31 Mar 2026 19:52:47 GMT

@AntonPineiro ,

That shouldn't be an issue with extensions. After all, the WMI extension, for instance, is suggested to monitor servers or systems that are not supported by OneAgent...

Re: SQL Server Extension failing to connect to server

AntonioSousa — Mon, 06 Apr 2026 21:45:41 GMT

This hasn't been referenced here. The best reference for this issue is:
https://community.dynatrace.com/t5/Heads-up-from-Dynatrace/OpenJDK-17-0-18-change-in-Extension-Execution-Controller/tac-p/297310

Re: SQL Server Extension failing to connect to server

tarjei — Fri, 24 Apr 2026 11:24:46 GMT

Has anyone gotten to the bottom of this issue?

Re: SQL Server Extension failing to connect to server

AntonioSousa — Fri, 24 Apr 2026 14:13:07 GMT

@tarjei ,

Yes, it's a security issue. Dynatrace tries to connect, by default, using only modern ciphers/algorithms.

If you have older SQL Servers (I have managed to connect to 2005s), please follow the procedures referenced in https://community.dynatrace.com/t5/Heads-up-from-Dynatrace/Resolved-OpenJDK-17-0-18-change-in-Extension-Execution/tac-p/297310

Re: SQL Server Extension failing to connect to server

tarjei — Thu, 30 Apr 2026 13:47:59 GMT

I tried to remove all of the tls.disabledaøgprithms but still doesn't work