Hi,
Is this the connector
And the pins on the motherboard look like this:
If You notice on the side of the cable connector, You will see a small plastic lever, that is the lock which supposed to be attached to the motherboard connector frame, its edge. (Red arrow).
It should not be possible to misfit the connector into the motherboard slot because both is keyed, meaning that one can't put in wrong direction or even displaced on either side.
However, if as you said You applied excess force to press it down I guess it is possible.
Now, the important thing is that you check each and every pin on both sides, to make sure that none is bent or broken.
I can't see why is not going to work, unless You have a broken or bent pin/connector in one of these.
As You can see on the picture above: there are no holes but asymmetric holes, that must fit into the corresponding cable connector.
So make sure to begin with that all of them are straight and ok, then make sure that the Molex 24-pin cable connector fits straight into the slots and indeed rotated correctly so it will fit into the motherboard connector.
Best regards from Sweden
[Edit] Btw. in some powersupply's, they have a special connector: it has only 20-pin and a loose 4-pin connector that must be tacked to the main cable connector before putting it down to the motherboard connector..
You will immediately notice this, if.