×

Are you a member of the Splunk Community?

Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question
arusishere
New Member
Member since: ‎04-13-2025
‎04-15-2025
Community Statistics
Posts 3
Solutions 0
Karma Given 0
Karma Received 0
Member Since ‎04-13-2025
Activity Feed
Topics I've Started
View All

Re: Splunk DB Connect Addon

by in Getting Data In
‎04-15-2025 04:41 PM
‎04-15-2025 04:41 PM
Hi Isoutamo, Thank you for the quick response. I'll take a look at the link provided for troubleshooting. In the meantime to answer your questions... We are using DB connect 3.18.2 which is the newest version. We do have the updated JRE version that is compatible installed (JDK 17).  I've confirmed Java is indeed working by running the java version command on the server. It indeed comes back with the installed version so the environmental variable is confirmed working and correct. Also, the DB connect page would not work correctly if Java is not installed. I am able to navigate to the page so we can probably rule Java being an issue out. Will post a solution/update once I go through that troubleshooting page. Kind Regards, ... View more

Re: Splunk DB Connect Addon

by in Getting Data In
‎04-15-2025 04:36 PM
‎04-15-2025 04:36 PM
Hello Livehybrid, Thank you for the quick response. We did indeed try Windows Authentication. We have confirmed the permission and password is correct as we attempted to login with the account. Access rights are also correct as we were able to navigate the necessary areas of the database. We also tried the SQL authentication. We even made a direct SQL account when we attempted SQL authentication (non windows auth). No luck there either. I have failed to mention in my original post the DB connect version. We have 3.18.2 installed. We also have all the necessary JDBC drivers installed. If there are any other data points I can provide to assist with getting some help on this please let me know. Kind Regards, ... View more

Splunk DB Connect Addon

by in Getting Data In
‎04-13-2025 09:54 PM
‎04-13-2025 09:54 PM
Dear Splunk Community, I need some advice on how to get DB Connect configured. I'm hitting a brick wall trying to get it up and running. I believe I have done the driver installs, database connection settings, JDK install, and set environment variables correctly. I have gotten to the point where we can see login errors in the SQL server logs. With this, I know the servers are attempting to communicate. Here is the system setup: Splunk OS: Windows Splunk Version: 9.0.9 JDBC Drivers installed: 12.4 Connection settings: Tried both MS-SQL Generic and Windows Authentication Database OS: Windows Server 2016 (SQL 2019) Errors received from different attempts: Login failed for user xxx (On splunk) This driver is not configured to perform integrated authentication. (On splunk) Login failed for use <username> Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. (On Windows SQL) My resources: https://lantern.splunk.com/Splunk_Platform/Product_Tips/Extending_the_Platform/Configuring_Splunk_DB_Connect The splunk documentation labyrinth. I would also like to add that I've gone through the labyrinth of documentation Splunk provides (it's overwhelming). Also, oddly enough, a friend with a very similar environment is having the same issue. Any advice would be much appreciated. And no, I will not install the JTDS drivers that some people recommended. It's open source and 10+ years old. Splunk's provided procedures and documentation that should work.   Thanks for your help. First time posting!   Kind Regards, ... View more
Labels
Contact Me
Online Status
Offline
Date Last Visited
‎04-15-2025 04:32 PM