Splunk Search

Connect to a non-default instance of MS SQL server

Dan
Splunk Employee
Splunk Employee

How would I connect to a non-default instance of MS SQL server? I don’t see any fields in the GUI or database.conf.spec for that. With MS tools or ODBC settings, I’d just specify SERVER\INSTANCE but that doesn’t seem to work with DBX.

1 Solution

Dan
Splunk Employee
Splunk Employee

At the moment, you can specify the named instance in the database field as:

<instance>/<database>

eg.
someinstance/northwind

or in database.conf:

database = someinstance/northwind

Alternatively you can specify the TCP port the named instance is listening on.

[Thanks to Siegfried for the answer]

View solution in original post

the0duke0
Path Finder

In my case when using the DBConnect 2.3.1 and MS Generic driver, I had to edit the JDBC URL format to omit the :<port> tag, leaving it as:

jdbc:sqlserver://<host>;databaseName=<database>;selectMethod=cursor

You can do this within the connection screen. Then you can specify the Server field as <servername>\<instancename>, as you normally would for named instances.

igritsak
Engager

Removing the and changing the Host filed to use the typical MSSQL convention is what finally worked for me. Thank you!

0 Karma

ktvrznik
Loves-to-Learn Lots

Confirm that. If you remove port from JDBC URL. Its working

0 Karma

Dan
Splunk Employee
Splunk Employee

At the moment, you can specify the named instance in the database field as:

<instance>/<database>

eg.
someinstance/northwind

or in database.conf:

database = someinstance/northwind

Alternatively you can specify the TCP port the named instance is listening on.

[Thanks to Siegfried for the answer]

gfuente
Motivator

Thanks for the answer. This should be in the documentation

Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...