Appreciate any other suggestions!
text for the cable reads like it should be the correct item.
sounds like the hardware chain may be okay except for maybe the drive.
"The Joys of debugging used hardware!"
PWDIS
Another thought is PWDIS - but I thought that was a feature exclusive to SATA disks (and I could be wrong on that thought)
Here's how to work around that (thought there are plenty of how-to's online):
Non-destructive methods:
If you have a molex to SATA female power adapter cable and a spare molex connector on your PSU (or one you can use for testing by unplugging a non-essential device) then use that molex adapter cable to feed power to your SAS adapter thing-a-ma-jig. The molex adapter does not provide 3.3v and thereby disable the PWDIS function. Your local computer store might have them too - in the USD new at a store probably $5 USD.
If you have kapton tape, steady hands and possibly a mangifying glass you can try taping off pin 3 on the SSD's power connector. This is fiddly and simply installing your SAS adapter thingy could move the kaptop tape etc.
There are destructive methods. my advice: try and test PWDIS in a non destructive fashion.
Other paths that you've probably thought of but I'll ask just in case?
Is there a BIOS enabled on this card? Or does the BIOS simply list the HBA on the screen during boot?
ie. Does something like press Ctrl-<whateverKey> to enter setup appear during the boot process?
If yes does the SAS SSD show up in the HBA's BIOS utility? If this is UEFI then probably no BIOS setup in the card.
Have you tested all 8 of the ports on your 8654 cable with the SAS SSD?
If not I'd power down between each test attempt.
Do you have a known good SAS disk? One that you could temporarily install with your HBA->cable->adapter->Test SAS disk to make sure the whole chain really is working? If not then ask in the WTB/WTS to see if someone local to you has a drive you can borrow?
Or do you know someone locally with a SAS capable server that would test the drive for you?
alternatively if there is a low cost SAS-3 disk you can get off the bay locally (fast ship) to test that might be a route - low cost is key because you're basically buying a disk you may not use again.
Your garage nas? does it have a SAS HBA? SAS backplane? Spare bay and connection to SAS HBA? Can you test the SSD in there?
If you would have to pull a drive from the NAS to test then you'd probably NOT want to boot into whatever OS it is running otherwise the array may get flagged with a failure...
I realize your ultimate installation is the hardware chain you've purchased - but just offering suggestions to rule out whether the drive is really DOA or not.