Getting Data In

Database connection Failed Error- Splunk DBconnect

Roy_9
Motivator

Hello All,

I have created identities and when i am trying to create a new connection to ms-sql server, i am getting "database connection is invalid"

 Login failed for user svc_account. ClientconnectionId: ------

 

 

 

Labels (1)
0 Karma
1 Solution

Roy_9
Motivator

@leonard_dupray  yes, i have installed the drivers but its not authenticating when i am using MS-SQL Server Generic Drivers and Generic drivers using windows authentication.So i tried with the route of using jTDS driver with windows authentication and surprisingly it worked.

View solution in original post

0 Karma

leonard_dupray
New Member

Have you installed the SQL drivers? Process is in the docs.

0 Karma

Roy_9
Motivator

@leonard_dupray  yes, i have installed the drivers but its not authenticating when i am using MS-SQL Server Generic Drivers and Generic drivers using windows authentication.So i tried with the route of using jTDS driver with windows authentication and surprisingly it worked.

0 Karma
Get Updates on the Splunk Community!

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0

Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...