Please help -- So stuck now -- Cant connect to sql from external source

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

    Please help -- So stuck now -- Cant connect to sql from external source

    Hi all,

    I am having real problems allowing a client to connect to sql 2000
    through enterprise manager.. I have tried all sorts but to no avail:

    From our local network all works fine.. Using the adsl line.. Even if
    i try and connect to the external IP and use login details..(As
    opposed to connecting local and using windows accounts) I can ping and
    telnet the server and port.

    The server is behind a firewall so i opened up port 1433 and port
    1434(? is it needed).. To replicate the client i took the same laptop
    home that i use to connect in the office.. However using the exact
    same config on my dial up at home i can ping the server but cannot
    telnet onto port 1433.. I think that this is the vital missing step
    but do not know hpw to resolve it..

    Any ideas anyone

    Cheers
    Ant
    Tags: None
    • Simon Hayes
      #2
      Re: Please help -- So stuck now -- Cant connect to sql from external source

      anthonykallay@h otmail.com (Anthony) wrote in message news:<77112a1e. 0309040245.6d42 6db9@posting.go ogle.com>...[color=blue]
      > Hi all,
      >
      > I am having real problems allowing a client to connect to sql 2000
      > through enterprise manager.. I have tried all sorts but to no avail:
      >
      > From our local network all works fine.. Using the adsl line.. Even if
      > i try and connect to the external IP and use login details..(As
      > opposed to connecting local and using windows accounts) I can ping and
      > telnet the server and port.
      >
      > The server is behind a firewall so i opened up port 1433 and port
      > 1434(? is it needed).. To replicate the client i took the same laptop
      > home that i use to connect in the office.. However using the exact
      > same config on my dial up at home i can ping the server but cannot
      > telnet onto port 1433.. I think that this is the vital missing step
      > but do not know hpw to resolve it..
      >
      > Any ideas anyone
      >
      > Cheers
      > Ant[/color]

      This KB article explains what firewall configuration is required:

      Error - Office.com
      http://support.microsoft.com/default.aspx?scid=kb;en-us;287932


      Simon

        Comment

        Previous template Next
        Working...