Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Route ODBC over VPN, no direct SQL server access


  • Please log in to reply
1 reply to this topic

#1 Rylando

Rylando

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:09:17 PM

Posted 14 April 2016 - 12:16 PM

We have a client with multiple sites that need access to their SQL instance to run a small application locally. The SQL server resides outside of their current phase 2(s) and we would prefer not to modify these tunnels. They only point to the RDC Gateway, so a single IP.

 

My question is, can I reroute an ODBC connection so it comes from the local PC, through the gateway server and on to the SQL server without exposing the SQL server?

 

Sorry if this is SQL based and not networking.



BC AdBot (Login to Remove)

 


#2 Wand3r3r

Wand3r3r

  • Members
  • 2,027 posts
  • OFFLINE
  •  
  • Local time:06:17 PM

Posted 14 April 2016 - 11:59 PM

ODBC isn't a protocol and as such can't be routed.

 

Can you have a direct connection via the internet from the client to the sql server via the internet using odbc?  yes

Recommended?  NO  You want a secure connection as well as a hardened sql server.

 

https://technet.microsoft.com/en-us/library/ms175483(v=sql.105).aspx






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users