Unity Replication Monitor "RED X"

Unanswered Question
Jul 22nd, 2008

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)

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
thfergus Tue, 07/22/2008 - 06:24

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