To setting up Microsoft Failover Cluster there are some specifics requirements. (in our case related to SQL)
First of all allow all cluster nodes must access shared disk sending iSCSI commands.
Here they are complete requirements.
To allow this configuration on Vmware Cloud Director it is necessary to create Named Disk.
Here it is official documentation that confirm that this configuration is feasible
https://www.bdrsuite.com/blog/vmware-cloud-director-named-disks/
Finally here they are some screenshots: