https://community.splunk.com/t5/All-Apps-and-Add-ons/How-to-connect-to-a-non-default-instance-of-MS-SQL-server-from/m-p/391647#M47836 <P>Does this work if you're not using the JTDS driver?</P> Thu, 14 Mar 2019 22:40:42 GMT rssimonis 2019-03-14T22:40:42Z https://community.splunk.com/t5/All-Apps-and-Add-ons/How-to-connect-to-a-non-default-instance-of-MS-SQL-server-from/m-p/391645#M47834 <P>There is already a <A href="https://answers.splunk.com/answers/66459/connect-to-a-non-default-instance-of-ms-sql-server.html">post</A> 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.<BR /> I am using jtds driver<BR /> 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.</P> Fri, 03 Aug 2018 04:27:28 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/How-to-connect-to-a-non-default-instance-of-MS-SQL-server-from/m-p/391645#M47834 damode 2018-08-03T04:27:28Z https://community.splunk.com/t5/All-Apps-and-Add-ons/How-to-connect-to-a-non-default-instance-of-MS-SQL-server-from/m-p/391646#M47835 <P>found the answer,<BR /> Below is the format :</P> <PRE><CODE>jdbc:jtds:&lt;server_type&gt;://&lt;server&gt;[:&lt;port&gt;][/&lt;database&gt;][;&lt;property&gt;=&lt;value&gt;[;...]] </CODE></PRE> <P>Example: jdbc:jtds:sqlserver://IP:1433/master;instance=SQLEXPRESS;user=sa;password=s3cr3t</P> Fri, 03 Aug 2018 05:23:38 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/How-to-connect-to-a-non-default-instance-of-MS-SQL-server-from/m-p/391646#M47835 damode 2018-08-03T05:23:38Z https://community.splunk.com/t5/All-Apps-and-Add-ons/How-to-connect-to-a-non-default-instance-of-MS-SQL-server-from/m-p/391647#M47836 <P>Does this work if you're not using the JTDS driver?</P> Thu, 14 Mar 2019 22:40:42 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/How-to-connect-to-a-non-default-instance-of-MS-SQL-server-from/m-p/391647#M47836 rssimonis 2019-03-14T22:40:42Z