Background: There's an A controller and a B controller. I think they're labelled as such by arrows on the left side of the picture you posted in the middle of the box.
Each controller is connected to one of the two signal paths to a SAS HDD. SATA has only one path, so will be connected only to one controller, or will have an interposer capable of making two paths appear as one to the disk. There are separate part numbers for SAS and SATA interposers, so there may be a point of difference there specifically for SATA disks. Why are there two SAS ports per controller card? One's an uplink to the HBA, the other a downlink to another downstream 'daisy chained' shelf.
TLDR; if the drive doesn't show up, connect to the other controller card instead.