Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Unanswered: Connecting to Remote SQL server - time out expired?

    Hello

    Im connecting to a remote SQL Server in Enterprise Manager Via VPN,

    we checked the connection and everything but still o cant connect

    to the remote server, Error message says "Time Out Expired",

    we checked the firewall config, ADSL connection and it's all Ok


    what seems to be the problem here??

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by samsmic
    Hello

    Im connecting to a remote SQL Server in Enterprise Manager Via VPN,

    we checked the connection and everything but still o cant connect

    to the remote server, Error message says "Time Out Expired",

    we checked the firewall config, ADSL connection and it's all Ok


    what seems to be the problem here??
    There are oh so many possibilities...

    1. Can you telnet to the remote server on the correct port?
    2. Is there another firewall at the other end (I assume so since it's a VPN)? If so, can you verify that the traffic is getting beyond that firewall?
    3. Are both firewalls set to handle the "hand-off" that occurs when incoming traffic on port 1433 is handed off to a negotiated port? This is usually automatic, but on some older firewalls, it must be manually configured.
    4. Are you using hostname or IP address to connect? If hostname, what is the name resolution service running (I assume DNS)? If DNS, are you sure about the IP Address resolution?
    5. Are you NAT'ing the internal IP addresses? Are the NATs configured correctly.

    Look at your firewall logs carefully (hopefully there's a nice GUI to help you). The answer is likely in there somewhere. It may not be easy to find, but it's in there.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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