Unity Replication Monitor "RED X"

Unanswered Question
Jul 22nd, 2008
User Badges:

On my primary Unity server, replication is not working. Currently my

seconday server is acting as primary and I would like to failback to primary. However I

notice the red X on Replication with the following error:


Server: CHS-UNITY, Database UnityDb : ODBC Error:Could not change the Publisher because

the subscription has been dropped. Use sp_subscription_cleanup to clean up the triggers.


Any way to fix this without rebuilding my Unity server? We are running Unity 4.2(1)

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
thfergus Tue, 07/22/2008 - 06:24
User Badges:
  • Cisco Employee,

Ensure the MSSQLSERVER and SQLSERVERAGENT services are running under the correct account. The account must be a domain account and must:


•Have the right to log on as a service.


•Be a member of the local Administrators group.



Check the secondary server name on the unitydb through query analyzer with "select

@@servername account. If is different


It was different, follow the procedure below to change to correct name :

- stop Unity

- stop SQLSERVERAGENT

- open Query Analyzer

- use the following commands:


sp_dropserver '', 'droplogins'

sp_addserver '', 'local'



reboot the secondary server

- open Query Analyzer and use 'select @@servername' to confirm the correct secondary servername is registered


- rerun Failover Configuration Wizard


Actions

This Discussion