Hi @SQLServerBro ,
only way to bring sql server cluster resource online is by manually starting both sql server and sql server agent services manually and then manually bring cluster resource online.
No. This is abnormal. Both sql server and sql server agent services are cluster resources. Both sql server and sql server agent services are cluster resources. When the failover is completed, the resource will be online on the active node.
Please see: https://learn.microsoft.com/en-us/troubleshoot/sql/failover-clusters/cluster-resource-goes-failed-state
If your problem is not resolved, can you post some error messages like the symptoms in this document?
Best regards,
Seeya
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.