Archive

Connect to a non-default instance of MS SQL server

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

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

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.

Engager

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

0 Karma

New Member

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

0 Karma

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

Motivator

Thanks for the answer. This should be in the documentation