topic Where should I open firewall to connect the Splunk DB Connect App to the database (Indexer or Search Head) & what port? in All Apps and Add-ons https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360912#M43604 <P>I recently installed the Splunk DB Connect App in a distributed environment. Splunk version is 6.5.3. The database I want to ingest MS SQL data on port 1433. I wanted to know where (search head or indexer) to open port 1433 to get connectivity to the database and DB Connect App?</P> Wed, 09 Aug 2017 18:59:12 GMT u2s1e0n2 2017-08-09T18:59:12Z Where should I open firewall to connect the Splunk DB Connect App to the database (Indexer or Search Head) & what port? https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360912#M43604 <P>I recently installed the Splunk DB Connect App in a distributed environment. Splunk version is 6.5.3. The database I want to ingest MS SQL data on port 1433. I wanted to know where (search head or indexer) to open port 1433 to get connectivity to the database and DB Connect App?</P> Wed, 09 Aug 2017 18:59:12 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360912#M43604 u2s1e0n2 2017-08-09T18:59:12Z Re: Where should I open firewall to connect the Splunk DB Connect App to the database (Indexer or Search Head) & what port? https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360913#M43605 <P>Enable outbound connectivity on the host that runs DBX and the JDBC client.</P> Wed, 09 Aug 2017 19:07:07 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360913#M43605 s2_splunk 2017-08-09T19:07:07Z Re: Where should I open firewall to connect the Splunk DB Connect App to the database (Indexer or Search Head) & what port? https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360914#M43606 <P>Thanks so much for the reply. How do I do that? I have 5 search heads (clustered) and the DBX was pushed out through the Deployer. Do I open outbound from the 5 Search heads (Clustered)? Also the how do I open the connectivity on the JDBC client? Any steps to follow?</P> <P>Thanks</P> Wed, 09 Aug 2017 19:12:29 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360914#M43606 u2s1e0n2 2017-08-09T19:12:29Z Re: Where should I open firewall to connect the Splunk DB Connect App to the database (Indexer or Search Head) & what port? https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360915#M43607 <P>You need to ensure that every SHC member has network connectivity to your database server. How you do that is completely dependent on your network environment, so I can't really answer that.<BR /> DBConnect uses whatever connection URL you specify. <BR /> Are you getting connection errors similar to what is <A href="https://answers.splunk.com/answers/488895/splunk-db-connect-how-to-resolve-mysql-connection.html">described here</A>? </P> Wed, 09 Aug 2017 19:18:16 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360915#M43607 s2_splunk 2017-08-09T19:18:16Z Re: Where should I open firewall to connect the Splunk DB Connect App to the database (Indexer or Search Head) & what port? https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360916#M43608 <P>This is the error message.</P> <P>The TCP/IP connection o the host 10.X.X.X port 1433 has failed. Error: ' Connection timed out: no further information . verify the connection properties. Make sure that an instance of SQl is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by firewall."</P> Wed, 09 Aug 2017 20:01:15 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360916#M43608 u2s1e0n2 2017-08-09T20:01:15Z Re: Where should I open firewall to connect the Splunk DB Connect App to the database (Indexer or Search Head) & what port? https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360917#M43609 <P><A href="https://answers.splunk.com/answers/386765/splunk-db-connect-2-why-am-i-getting-this-connecti.html">This thread</A> has the troubleshooting steps in it. Your network folks will be able to help you figure out why you cannot connect from sourceIP(SHC) to targetIP:1433 <BR /> Most likely they need to put some firewall rules in place for you.</P> Wed, 09 Aug 2017 21:47:41 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Where-should-I-open-firewall-to-connect-the-Splunk-DB-Connect/m-p/360917#M43609 s2_splunk 2017-08-09T21:47:41Z