Small PCB With Broken SATA Port

[jpascone]

The title pretty much says it all, see photos. Options I would like to pursue:
(1) MacGyver fix I could venture alone acquiring items locally.
(2) Parts I could order online specifically for this kind of situation.
(3) My brother is an EE, I could mail him the board and a replacement socket (where do I get one?) and have him send repair back to me but this is tough because he travels or pay a fee to someone here to handle repair?
Thanks Tom's!
Jeffrey

 

[Rookie_MIB]

I had a problem similar to this before, I used a little bit of epoxy to put the plastic tab in, then put the cable back in carefully and connected the sata cable to it. Made sure it worked.

Then used a big blob of epoxy to permanently attach the cable to the board. Board is still in use 6 years later...