Post reply

What is the best way to access a sql server in another country using the public ip address?

  • February 16, 2013 at 9:28 am

    #394201

    I can access my sql server when both of my computers are connected to a same router. However, when one is connected in another router, it does not connect anymore. What should I do? Please help!

  • February 16, 2013 at 11:43 am

    #1588615

    I think the primary thing that you can or should check is whether the server itself is reachable by a ping.

    if you can ping the server successfully, the next step then would be to use telnet to connect to the port on the destination server that the sql server is listening on.

  • February 16, 2013 at 11:47 am

    #1588616

    can you teach me how to ping?

  • February 16, 2013 at 12:01 pm

    #1588617

    i have pinged it. what's the next step?

  • February 17, 2013 at 6:19 am

    #1588662

    Telnet "servername" "portname"

    where portname is the TCP port on which sql server is listening on ( you can get this information from the error log)

    if Telnet does not work you will get an error, if it works you will get a blank screen.

  • February 17, 2013 at 6:38 am

    #1588663

    Check if your MAC address is allowed. Check the firewall and remote settings.

    Igor Micev,My blog: www.igormicev.com

  • February 18, 2013 at 7:13 am

    #1588841

    Were you able to resolve your issue?

    I find that using PortQryV2 is a bit better than telnet to diagnose issues with SQL Server. See if you can query the necessary ports on your SQL Server instance when connected to the other router

    TCP 1433 is the default TCP port for a default instance. if it's a named instance you'll have to look up what it's using.

    UDP 1434 is what the SQL Browser uses

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply