SQL Server Performance

SQL Clustering & Replication

Discussion in 'SQL Server Clustering' started by sani, Jun 25, 2007.

  1. sani New Member

    Hi All,

    I have installed SQL Server Clustering and it works fine. I need to enable replication between one of the existing DB in Cluster and a single SQL Server. SQL Cluster is publisher and the other server is Distributor and Subscriber. When I want to configure the publisher I got the following error message and it fails to continue the process.
    "It couldn't determine the virtual server name as remote server and try to connect to one of the cluster node."
    But in distributor definition when I enter virtual server name it accept the name and continue configuring the distributor.
    Please let me know is there specific setting to do before starting Replication configuration.

    Many thanks,
    Sani.
  2. satya Moderator

    When configuring replication with clustered servers, create a MSCS file share for replication to be configured against so all cluster nodes will be able to access it in the event of a failover.

    Also fYI;
    http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=110
    http://www.sql-server-performance.com/q&a24.asp

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. sani New Member

    Hi Satya,

    I have created shared folder on Distributor. Is there anything wrong in this scenario?

    Regards,
    Sani.
  4. satya Moderator

    Have you tried using IPAddress?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. newchina New Member

    which option "locate the Distributor on a non-clustered SQL Server" or "locate the Distributor on a clustered SQL Server' affect the performance most?

    we had the "locate the Distributor on a clustered SQL Server" and it blocked the network traffic--decrease the SQL server performance. so we had to remove the replication.


    what do we need to consider when we want to set up the clustering and replication on our system?


  6. MohammedU New Member

    I have replication configured on the cluster server without any issues why the distributor blocks network traffic...

    First of all make sure your stand alone server can see the cluster server and better create a linked server on stand alone to cluster server before configuring the replication.

    If you have any issues with the name You can create an alias on the stand alone server using the ip address...


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page