All Apps and Add-ons

How to connect to a non-default instance of MS SQL server from Splunk DB Connect app version 3.1.3?

damode
Motivator

There is already a post for this question but it deals with DB Connect app version 1. I tried to use the same solution but it doesnt seem to work for me.
I am using jtds driver
Can someone please advise how I can create a DB connection to a instance of an SQL Server. I already have configured connection to the default Database. For e.g, I have configured connection to ServerA but unable to configure connection to ServerA\Instance.

0 Karma
1 Solution

damode
Motivator

found the answer,
Below is the format :

jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]

Example: jdbc:jtds:sqlserver://IP:1433/master;instance=SQLEXPRESS;user=sa;password=s3cr3t

View solution in original post

0 Karma

damode
Motivator

found the answer,
Below is the format :

jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]

Example: jdbc:jtds:sqlserver://IP:1433/master;instance=SQLEXPRESS;user=sa;password=s3cr3t

View solution in original post

0 Karma

rssimonis
New Member

Does this work if you're not using the JTDS driver?

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!