SQL Server Performance


Discussion in 'SQL Server 2005 Log Shipping' started by Rabani, Apr 9, 2009.

  1. Rabani New Member


    Can any one please, tell me that when we configure log shipping do we have to open a firewall from the destination server to the source server too.

  2. vikasrana_dba New Member

    1) On Secondary Server firewall, open port 1433 so that primary server can connect to it.
    2) Make sure File Sharing is enabled on the local area connection between the servers. Also enable file sharing in Firewall.
  3. satya Moderator

    If you can connect to secondary server from the primary server with a simple query then no need to open any specific ports on secondary server.

Share This Page