Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Unity Replication Monitor "RED X"

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 REPLY
Cisco Employee

Re: Unity Replication Monitor "RED X"

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

160
Views
0
Helpful
1
Replies
CreatePlease login to create content