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!

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...