All Apps and Add-ons

Splunk DB Connect - setting a MSSQL server

abovebeyond
Communicator

Hi all,

I am trying to set a new connection in "Splunk DB Connect" (latest version) to a MSSQL server.
i choose connection type ' mssql generic driver and reciving the following error:

Internal server error, originalErrorMessage=No suitable driver found for jdbc:sqlserver://myserver:1433;databaseName=master;selectMethod=cursor

Anybody can help me to set it right?
Thanks!

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Make sure you've installed the driver. See http://docs.splunk.com/Documentation/DBX/3.0.3/DeployDBX/ConfigureDBConnectsettings

---
If this reply helps you, an upvote would be appreciated.
0 Karma

abovebeyond
Communicator

Thank you, i installed the 4.2 driver version.

Now I'm receiving an error for login failed:

"Internal server error, originalErrorMessage=Login failed for user 'domain\user'. ClientConnectionId: ....."

While this user is working for 'splunk db connect 1'

Thanks !

0 Karma

abovebeyond
Communicator

an update.
this is a windows domain user. i assume i need to use the "MSSQL with windows authentication"

while trying to use it, I'm receiving the following:

"Internal server error, originalErrorMessage=This driver is not configured for integrated authentication"

0 Karma

richgalloway
SplunkTrust
SplunkTrust

I don't know anything about that error.

Perhaps this answer will help: https://answers.splunk.com/answers/334028/splunk-db-connect-2-why-am-i-getting-this-driver-i.html

---
If this reply helps you, an upvote would be appreciated.
0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!