SQL Clustering & Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Clustering & Replication

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.

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.
Hi Satya, I have created shared folder on Distributor. Is there anything wrong in this scenario? Regards,
Sani.
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.
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?

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.

]]>