Post reply

Replication Connection Problems

  • January 30, 2007 at 3:39 pm

    #116077

    I am setting up replication between Server A and Server B cross WAN.

    Server A is running SQL Server 2005 and Server B run SQL Server 2000.

    1. Testing network connection both servers 

    2. Setup alias both servers.

    When I try to bring Server B in Microsoft SQL Server Management Studio.

    I got the error of:

    "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)."

    I am research and try to find solutions.  Did anyone aware of this problems?

    Thank you.

    TJ 

  • January 30, 2007 at 4:17 pm

    #686636

    Are you able ping both server from one to another?

    Why are you creating alias? You mean linked server?

    Are you able to connect remote server with QA?

     

    MohammedU
    Microsoft SQL Server MVP

  • January 30, 2007 at 4:58 pm

    #686652

    In SQL Server 2005, I create the alias in SQL Native Client Configuration.

    And, in SQL Server 2000, I create the alias in  SQL Server Client Network Utility.

    Both servers can communications.

    Thanks

    TJ

  • January 30, 2007 at 6:25 pm

    #686661

    We you create alias they can't communicate with each other...

    First check you can access the remote server from Query Analyzer.

    Check the following article...

    http://www.sql-server-performance.com/pi_replication_across_internet.asp

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 4 posts - 1 through 3 (of 3 total)

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