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.

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.


© 2021 - DevGraph | An integrated suite of software development tools from DevFactory FZ LLC, an ESW Capital Group Company | Contact Support

401 Congress Avenue, Austin, TX 78701 | Email: scalearc-support@devgraph.com 




Please sign in to leave a comment.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request