KB 3013 - Auto Failover Error.
|Release||Document Status||DB Platform||Categories|
|3.0 or later||INFO||All||AutoFailover|
User gets the following error message while trying to configure auto failover in ScaleArc.
In order to perform Auto Failover operations in ScaleArc a user must have the appropriate privileges. A user must be able to execute the following commands on the server:
select @@SERVERNAME as servername;
query4 = "exec sp_replmonitorhelppublication @publisher='%s'" %publisher
query4 = "exec sp_replmonitorhelppublication @publisher='%s'" %publisher publisher_db = '%s', @publication = '%s',\
@publication_type = 0;" %(publisher, publisher_db, publication)
Please confirm the above permissions prior to performing Auto Failover in ScaleArc.
If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support. We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315. For general support inquiries, you can also e-mail us at firstname.lastname@example.org.
2901 Tasman Drive Santa Clara, CA 95054 | Email: email@example.com