Hello,
In a test environment I am trying to change the roles of the database and I am able to run sp_change_primary, sp_change_secondary, and the sp_resolve_logins, but when I go to run the sp_change_monitor it keeps failing with the error:
Server: Msg 14442, Level 16, State 1, Procedure sp_change_monitor_role, Line 18
Role change failed.
If anyone know why please let me know, I can not find any information on this problem. The only thing I found was to run sp_resolve_logins first which I did but it still does not work.
Thanks in advance,
Belinda