KB 3013 - Auto Failover Error

User gets the following error message while trying to configure auto failover in ScaleArc.

KB 3013
User account provided does not have privilege need to perform auto failover operations.
Please increase the privilege if you plan to use ScaleArc Auto Failover.
Do you want to continue?

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:

use distribution;

select @@SERVERNAME as servername;
exec sp_replmonitorhelppublisher;
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 its features, please contact ScaleArc Support.

We are available 24x7 by phone at +1 972-588-4221.

For general support inquiries, you can also e-mail us at scalearc-support@devgraph.com.