All Apps and Add-ons

Splunk DB Connect 2: Is it possible to use multiple Windows Authentication accounts to connect with multiple MS SQL databases?

jialiang123
New Member

Hi,

I have a use case in using multiple Windows accounts to log in into multiple MS SQL databases using Windows Authentication.

According to the documentation, I will have to configure the splunk service to run as the windows account. However, that will limit me to run as only a single account.

I need to account multiple MS SQL databases with each one using a different Windows authentication account.

Is this possible? I am still stuck with the DB connect 1 for this reason alone.
Please advise.

Thank you.

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

Hi, just to clarify: Windows integrated authentication is one thing, and using a Windows account to access a database is another. Connecting with Active Directory credentials (DOMAIN -backslash- USER) works on Linux or Windows. It does require careful handling of the domain field and JDBC URL: we’ve improved the out of the box templates for this in version 2.1.0: http://docs.splunk.com/Documentation/DBX/2.1.0/DeployDBX/Createandmanagedatabaseconnections and http://docs.splunk.com/Documentation/DBX/2.1.0/DeployDBX/Troubleshooting#Cannot_connect_to_Microsoft...

Integrated authentication requires the Microsoft generic driver, which uses OS libraries — you must use a Windows forwarder for this to work, and multiple forwarders on Windows is not supported (http://blogs.splunk.com/2014/04/07/running-two-universal-forwarders-on-windows/ for more info). There is a non-accepted patch to jTDS for this, but it is not supported by Splunk; also the jTDS driver means that you can’t use SSL or connection pooling: http://docs.splunk.com/Documentation/DBX/2.1.0/DeployDBX/Supporteddatabases

0 Karma
Get Updates on the Splunk Community!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...