do not tighten ?
the connector ?, it seems to me from the photos, a normal DB9
I'm not certain the knock-out reliability? link, but in all other sectors use data cables very often
for? ever tighten or less the screws were decisive
is what worries me
It may be that it has lost counted some welding. Try to open it and see if you find something...