Recently, I re-installed one of our SQL cluster nodes.
After the migration I re-installed the SQL instance for ConfigMgr on that node.
When testing failover, I noticed the SQL server service would not start and failed back or remained in failed state.
When I looked in the logs I found eventid 26014.
I checked if the certificate was available, and it was.
The certificate was in the correct store ( local computer / personal ) and had the correct cert hash.
When looking further at the private keys I noticed the service account did not have permissions on the failing node.
After adding the permissions for the service account the SQL service runs on, the instance started instantly without errors.
Took me a while to get there…. hope this helps someone else