SQL Server service update fails on active node in SQL Cluster

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

SQL Server service update fails on active node in SQL Cluster

L1 Bithead

CyberArk manages password rotation for a service account that is used for the SQL Server service in a SQL Cluster environment. I have a dependency linked to the SQL Server service so that the service configuration is updated when the password is rotated. Currently, when the password changes, it changes the passive node service, but fails on the active node. What am I doing wrong?

2 REPLIES 2

L7 Applicator

Hi @Johan Vermeulen​ 

 

Few possible reasons that comes to my mind are,

 

  • Please verify that the service account have the required permissions to update the service configuration on both the active and passive nodes. That is to restart and update the SQL Server service on both the nodes.
  • Verify that the dependency is correctly set to update the SQL Server service on both the nodes.

 

Please share the error messages from both CPM logs and from the SQL server.

 

 

L1 Bithead

This is the Failed to run ExecMethod on "host" with user "reconcile account" at domain xxxxxxxxx. Error: 0x80070056 Message: The specified network password is not correct. The CPM is trying to change this password because its status matches the following search criteria: ResetImmediately,Failure.

 

This is despite the same account being able to change the service configuration for another service on the same server. The same service successfully updated the service on the passive node

  • 221 Views
  • 2 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!