Unity Replication Monitor "RED X"

Peter Mirabile · ‎07-22-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)

thfergus · ‎07-22-2008

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