All Apps and Add-ons

I am unable to establish DB connection to MSSQL DB with Force Encryption enabled.


I am trying to connect to few of the MSSQL DB instances wherein the Force Encryption is enabled (set to true) and if I try to create DB connection through Splunk DB Connect Version: Build 1, it gives me error as *"I/O Error: DB server closed connection."*

While checking this issue on Splunk Answers portal, I have gone through similar question with title *"Splunk DB Connect 2: Why am I unable to connect to MSSQL with encryption?"*. But even though I set the connection parameters same as mentioned in that link, it doesn't work. After following this, I am getting error as
*"This driver is not configured for integrated authentication. ClientConnectionId:bc701e78-0062-4bb6-af77-7b6d4238a340"*

Here is the DB Connection input which I am using:- [DB_Connection] connection_type = generic_mssql_with_windows_auth jdbcURLFormat= jdbc:sqlserver://:/;useCursors=true;domain=;integratedSecurity=true;encrypt=true;trustServerCertificate=true
disabled = 0
identity =
localTimezoneConversionEnabled = false
port = 1600
readonly = true
database = master
host =
Please can someone assist me on this, as I am not able to find any other option to establish connection to the encrypted DB instances.


Were you ever able to get a solution for this issue? We are running into same problem.

0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...