Add new instance to SQL Server failover cluster 2019

Question

I have SQL server 2019 failover cluster with two nodes and i installed sql instance called aiprod and i'm able to move instance between the two nodes without issues.

now i created new instance with name sharedb from one of the nodes with dedicated ip address, disks and different service account .
but the setup does not complete as per below error message:

TITLE: Microsoft SQL Server 2019 Setup

------------------------------

The following error has occurred:
The cluster resource 'SQL Server (SHAREDB)' could not be brought online. Error: There was a failure to call cluster code from a provider. Exception message: One or more property values for this resource are in conflict with one or more property values associated with its dependent resource(s).
Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.2080.9&EvtType=0xD760FD9B%25400x1E6C367C

------------------------------

BUTTONS:
&Retry
Cancel

------------------------------

i'm trying to bring the resource online manually but it gives me the below error.

The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group

appreciate your suppport.

Answer 1

Hi @Mohamad El-Abd ,

You can look at the event log for more information about this error.

The possible reason is insufficient permissions, mark sure the account that was used to install SQL Server has the correct permissions in the cluster, the permission 'Create Computer Objects' should be granted to the Cluster Name Object

Open the avtive directory and computer snap-in
Locate 'Computer' container
Make sure 'Advanced Features' is selected
Open the properties of the container and click the 'Security' tab, click 'Add' and add the CNO, make sure to select 'Computers' option in the 'Object Types' window
Click 'Advanced', highlight the CNO, and click 'Edit'

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Answer 2

Maybe you already know this post otherwise it might help you:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2ddcd7d5-a10a-4446-bbd2-abea93cdaf97/failover-cluster-error-there-was-a-failure-to-call-cluster-code-from-a-provider?forum=sqlsetupandupgrade

On the otherhand we need more information from you on your environment, how do you connect those drives (local, SCSI, any virtual adapter, ISCSI, SMB)