Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Posts
    25

    Unhappy Unanswered: Connection Thru Internet

    Hello again pals, i meet you again to ask an old question i had, but no found answer.

    Can i connect to a remote SQL Server thru Internet, lets say from a client like Query Analyzer?

    I read to make it using a VPN, but i try to configure it and cant get connected.

    I'm using a Win2000 Server or Win2003 Server,

    Thanksfull!!!!

    There is many people asking for that, i start to think it cant be done! :'(

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    If you are using virtual private networking (VPN) to get onto the network where the SQL Server resides, yes you can access a SQL Server throught the internet. You need a router that allows for VPN, there is some configuration to do here and depending on your SQL authentication method, you are going to either have to setup accounts for the users NT logins(windows authentication) or setup user names and passwords for these users. Do'nt forget to assign them permissions within SQL as well.

  3. #3
    Join Date
    Feb 2004
    Posts
    25

    Arrow Other way?

    Quote Originally Posted by Thrasymachus
    If you are using virtual private networking (VPN)
    There is no other way to do it, without using VPN?, it has been a headache to try configure it!

    Thanks for your help Thrasymachus, is well received

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    This is the only way I can think of if you want use the QA to access the data. You can always create an online interface to do what your users need but it sounds like they need a lot of access.

  5. #5
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    If you know how to Telnet and use OSQL you can query your database from the command line

  6. #6
    Join Date
    Dec 2004
    Posts
    4
    If you make the ports that your server is listening on open to the internet you could connect directly. If you are using QA though I'd think you were doing some administrative tasks. You really shouldn't open up access to your server to the internet unless it's absolutely neccessary. If you can use a VPN, do it.

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Another way would be to set up port forwarding. But again it's as unsecure as directly exposing the server.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •