Hi all,
I have trouble connecting my test MSSQL with DB Connect.
I am able to connect the DB using DBVisualizer using the credential I use for the identity.
I am using the Generic MSSQL Driver:
The log:
2022-05-27 21:37:44.537 +0800 [dw-59 - GET /api/connections/mssql-test/status] INFO com.splunk.dbx.connector.logger.AuditLogger - operation=validation connection_name=mssql-test stanza_name= state=error sql='unknown' message='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:da36105c-f9e9-44e9-aeeb-023742b9a4eb'
I don't know why the error log shows SSL error when I have not enabled SSL for the connection.
Below is the db_connections.conf
[mssql-test]
connection_type = generic_mssql
database = master
disabled = 0
host = 192.168.74.238
identity = mssql-test
jdbcUseSSL = false
localTimezoneConversionEnabled = false
port = 1433
readonly = false
timezone = Etc/GMT
Thanks in advance.
... View more