SQL Server 2008 Cluster work with Replication

• 83873308

  SSC Enthusiast

  Points: 173

  More actions

  October 20, 2010 at 3:27 am

  #239992

  Hi,all.

  I'm getting the many error in Sql Server 2008 while i use cluster node to configure transaction replication.

  my domain :Terry-Corp.com

  i have a sql cluster

  Node 1 :MC01 (Server name)

  Node 2 : MC02

  SQL Cluster:MCCluster

  when i add a new publication ,i got error like 'can not connect to MCCluster,please use MC02'.

  so i sp_dropserver @server = 'mc02' and then add a sp_addserver 'MCCluster',local.

  everything goes well till i created a distrubtor.

  err:

  The Distributor has not been installed correctly. (Microsoft SQL Server，错误: 20036)

  i try to use other machine but also got this error..

  anyone has a full configuration step to solve this .

• Perry Whittle

  SSC Guru

  Points: 234064

  More actions

  October 20, 2010 at 2:18 pm

  #1239928

  going to need a lot more information hear my friend!!

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉