APMIA 2023.6.1.5 version MSSQl extension is not working

Products

• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

When upgrading to the APMIA 2023.6.1.5 version, the  MSSQL extension is not working. Getting the below error:

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:<id-number>', '0', 'com.microsoft.sqlserver.jdbc.SQLServerException'

• Support Analysis: however there is no changes we found in schema.jason but we found below document to update ";encrypt=true;trustServerCertificate=true" to work, as given it is working.

https://knowledge.broadcom.com/external/article/242092/java-processes-fail-to-start-the-driver.html

What is the changes to add ";encrypt=true;trustServerCertificate=true" when there is no changes in schema.jason or no changes from the MSSQL side

Environment

Release : 23.2

Resolution

Add the following to bundles.properties. to see MS SQL metrics in apm but not adding ";encrypt=true;trustServerCertificate=true" to schema.jason.

 

introscope.agent.dbmonitor.sqlserver.profiles.db1.authType=
introscope.agent.dbmonitor.sqlserver.profiles.db1.authenticationScheme=NTLM