???VPN connection to an SQL Server and/or database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Michael Holberton
    #1

    ???VPN connection to an SQL Server and/or database

    Hi All

    Can we connect remotely using SQL Server Enterprise Manager from our
    home PCs using a VPN connection, across the Internet, to an instance
    of SQL Server(or a database on it) that resides on an ISP's Server?
    Can this be done using a VPN IP connection? I believe a static IP is
    required for this?

    Thanks in Advance, Michael
    Tags: vpn sql
    • Leythos
      #2
      Re: ???VPN connection to an SQL Server and/or database

      In article <8a68c00d.03101 80406.41af69bf@ posting.google. com>,
      MikeTheBike@tpg i.com.au says...[color=blue]
      > Hi All
      >
      > Can we connect remotely using SQL Server Enterprise Manager from our
      > home PCs using a VPN connection, across the Internet, to an instance
      > of SQL Server(or a database on it) that resides on an ISP's Server?
      > Can this be done using a VPN IP connection? I believe a static IP is
      > required for this?
      >
      > Thanks in Advance, Michael[/color]

      You don't need a fixed IP to use VPN, but if the destination has a fixed
      IP it makes it easier to find the next time.

      If the SQL server doesn't have a fixed IP then you are asking for
      trouble.

      It's standard practice for workers at home to have dynamic IP's and the
      office to have fixed IP's.

      --
      --
      spamfree999@rro hio.com
      (Remove 999 to reply to me)

        Comment

        • John Bell
          #3
          Re: ???VPN connection to an SQL Server and/or database

          Hi

          There is not reason why this should not work, although if you are not
          part of the domain or on a trusted domain then you will probably have
          to use SQL authentication.

          I don't think a static IP is absolutely necessary, but it may be
          required by the firewall/router for authentication.

          John

          MikeTheBike@tpg i.com.au (Michael Holberton) wrote in message news:<8a68c00d. 0310180406.41af 69bf@posting.go ogle.com>...[color=blue]
          > Hi All
          >
          > Can we connect remotely using SQL Server Enterprise Manager from our
          > home PCs using a VPN connection, across the Internet, to an instance
          > of SQL Server(or a database on it) that resides on an ISP's Server?
          > Can this be done using a VPN IP connection? I believe a static IP is
          > required for this?
          >
          > Thanks in Advance, Michael[/color]

            Comment

            • Michael Holberton
              #4
              Re: ???VPN connection to an SQL Server and/or database

              Hi John,

              Thanks for your response. I couldn't set up a VPN connection but I was
              able to connect directly, using the IP Address, using Enterprise
              Manager. I had a brainwave earlier today and discovered I could also
              setup an ODBC connection using the IP Address and hence link to Tables
              from Access.

              Regards Michael

              jrm_bell@hotmai l.com (John Bell) wrote in message news:<59c6a934. 0310181029.1ffc f5ed@posting.go ogle.com>...[color=blue]
              > Hi
              >
              > There is not reason why this should not work, although if you are not
              > part of the domain or on a trusted domain then you will probably have
              > to use SQL authentication.
              >
              > I don't think a static IP is absolutely necessary, but it may be
              > required by the firewall/router for authentication.
              >
              > John[/color]

                Comment

                • John Bell
                  #5
                  Re: ???VPN connection to an SQL Server and/or database

                  Hi

                  If you are not using the VPN and have access restricted to those connecting
                  though the VPN then anyone can connect!!

                  John

                  "Michael Holberton" <MikeTheBike@tp gi.com.au> wrote in message
                  news:8a68c00d.0 310200113.2586b e5d@posting.goo gle.com...[color=blue]
                  > Hi John,
                  >
                  > Thanks for your response. I couldn't set up a VPN connection but I was
                  > able to connect directly, using the IP Address, using Enterprise
                  > Manager. I had a brainwave earlier today and discovered I could also
                  > setup an ODBC connection using the IP Address and hence link to Tables
                  > from Access.
                  >
                  > Regards Michael
                  >
                  > jrm_bell@hotmai l.com (John Bell) wrote in message[/color]
                  news:<59c6a934. 0310181029.1ffc f5ed@posting.go ogle.com>...[color=blue][color=green]
                  > > Hi
                  > >
                  > > There is not reason why this should not work, although if you are not
                  > > part of the domain or on a trusted domain then you will probably have
                  > > to use SQL authentication.
                  > >
                  > > I don't think a static IP is absolutely necessary, but it may be
                  > > required by the firewall/router for authentication.
                  > >
                  > > John[/color][/color]


                    Comment

                    Previous template Next
                    Working...