ODBC connection to private IP

Posted on 2012-09-18
Last Modified: 2012-09-28

I have a SQL server database that only has an internal IP address and the server does not face the outside; it is not NATed to a public IP address for security reasons.  I have a client that wants to connect to a view on the database through an ODBC connection on his end.  

I tried setting up a linked server with a SQL database that does face the outside, but not sure if I could create some sort of a tunnel that way.

All that I need is for this client to be able to connect via an ODBC connection to a view on an Internal database.  Is there a possible way to do this?
Question by:W2Market
    LVL 39

    Expert Comment

    by:Kyle Abrahams
    You could definitely create a tunnel by doing that.

    If they need to view it real time better to set them up with a VPN and give them access that way.

    If it's a one time thing give them a backup or a data dump of what they need to see.

    Author Comment

    A VPN would be great but that's out of the question and its not a one time thing either.  If I were able to create a tunnel though, I am unsure on how to do that, please elaborate.

    Author Comment

    Let me rephrase this.  Is it possible to setup an ODBC connection to a Linked Server?
    LVL 39

    Accepted Solution

    Sure it's possible.

    some pitfalls for 64 bit:

    By tunnel I thought you meant the security consideration.  Once you link the internet facing SQL server to the internal sql server you open up that hole for EVERYONE.  Sure they still need a username and password, but is this something you really want to do?

    Alternatively . . . another suggestion is to use logmein or some other 3rd party remote desktop sharing app that can run in the background.  This will give the user access to the PC over the web (or using an app depending on the client) and will simulate a VPN without fully establishing one.  All you need is a spare pc/laptop on your private network for this.

    Note the platforms used (EG: visual studios or management studio) will need to be installed on the "host" desktop (the one being connected to from the outside world) but IMO it's still a lot better than allowing anyone to connect to an internal database.  

    Last resort:   What about moving the database in question to the outside world.  Since you're going to be granting access anyway . . . you can take a backup and restore it on the internet SQL server and have everyone connect to that.  Has none of the risks of opening up the rest of the server while still granting access.

    Just some other thoughts and work arounds.  Let me know your thoughts and if you have any other questions.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now