Thread: SQL over VPN

  1. #1
    In your face... ha ha ha Liger86's Avatar
    Join Date
    Dec 2002
    Location
    Motorcity Capital
    Posts
    321

    SQL over VPN

    Hi guys.

    If someone could shine some light...

    I'm trying to access SQL database over VPN.

    I got bottom right running SQL server:

    SHIPPING-PC\WASPDBEXPRESS

    Should i be able to see this server over VPN? I can't setup VPN just yet, waiting for someone to give me password for firewall so i can enable forwarding to VPN.

    But after I get VPN setup, should the client computer automatically be able to see the SQL server when it connects to computer with the database? Or how much more setting up will it need, how hard can it be, right?
    From Ukraine with love!

    Internationally known – widely respected

    - Digitally yourz -

  2. #2
    Registered User slingerland3g's Avatar
    Join Date
    Jan 2008
    Location
    Seattle
    Posts
    603
    Not sure how this relates to this forum. Have you researched this at all? What I quickly found on the net was

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57799

  3. #3
    Officially An Architect brewbuck's Avatar
    Join Date
    Mar 2007
    Location
    Portland, OR
    Posts
    7,396
    The VPN software just provides a virtual network interface. The SQL server should not know or care what's going on. Once you've actually got the VPN configured, it should just work, as long as you're using the right IP address (i.e. the one the VPN has given you)
    Code:
    //try
    //{
    	if (a) do { f( b); } while(1);
    	else   do { f(!b); } while(1);
    //}

  4. #4
    Kernel hacker
    Join Date
    Jul 2007
    Location
    Farncombe, Surrey, England
    Posts
    15,677
    And of course assuming that the other end doesn't have anything stopping the VPN server from accessing the SQL server.

    --
    Mats
    Compilers can produce warnings - make the compiler programmers happy: Use them!
    Please don't PM me for help - and no, I don't do help over instant messengers.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. OOP Question DB Access Wrapper Classes
    By digioz in forum C# Programming
    Replies: 2
    Last Post: 09-07-2008, 04:30 PM
  2. Configuring VPN
    By ssharish2005 in forum Tech Board
    Replies: 5
    Last Post: 12-26-2006, 11:57 PM
  3. Embedded SQL
    By sarac in forum C Programming
    Replies: 1
    Last Post: 05-04-2006, 09:09 AM
  4. Replies: 1
    Last Post: 03-21-2006, 07:52 AM
  5. Problem with embedded SQL in C/C++ (ECPG)
    By NeuralClone in forum C Programming
    Replies: 4
    Last Post: 10-21-2005, 05:16 PM