After reading that the adapter works on other motherboards, then I suspect that the issue has to do with the PCIe bus on the motherboard where you are having trouble.
I have not looked up any specifications on your motherboard, but here are some things you can try that might help.
Do you have a different PCIe slot where you can install the Ethernet adapter? I have heard of some motherboards where one slot does not work, but another slot works.
You should also check if a BIOS update is available. Sometimes issues like you describe are fixed in BIOS upgrades.
I hope this helps.