If you want to use a sas breakout cable ie: 1 mini sas to 4x sata, it has to be a mini sas port you connect it to.
Even though it’s the same plug, I don’t think you can connect 4 sata disks to your m.2 slot via an adaptor. I don’t think the motherboard will know what to do with it.
But, if you get a m.2 to 4/8xpcie adaptor and then plug a hba card into that, then I think your goal can be achieved.
I can find some links when I get home.
I don’t have experience with these more generic hba cards, I use lsi 9211 cards in my nas. Though boot time is long af, because they have their own bios, which need to boot during system startup.
But I don’t see why either the startech or qnine card wouldn’t work, and they have good ratings on amazon.
You’re welcome
If you go for the m.2 adaptor route, then I’d just remove the bracket from the hba card, and just let it “hang loose” from the m.2 adaptor. It doesn’t weigh anything, so I don’t think it would matter that it’s not screwed in anywhere
I wanted to do something similar with M.2-to-PCIe-adapters.
Then I found this M.2 HBA:
But as far as I can tell it has only PCIe 2.0 x1, meaning about 400 MB/s for all 4 SATA drives :-/
In my opinion the best price-performance-power-consumption-heat part are 4 x SATA HBAs with the Marvell 9230 chipset that sports PCIe 2.0 x2, meaning 800 MB/s in total. If you only use 2 SSDs on one of those you don’t really notice a performance drop compared to the chipset SATA ports.
A1 chip revision (and later?) are pretty stable with updated firmwares.
The come in various form factors but be sure to check the vendors’ spec sheet for the electrical PCIe interface since it dictates the performance.
Edit: Hmmm the limited physical space above the PCIe slot seems to block the M.2 HBA.