Got a bad feeling about your DC-in power socket on your Mega Drive 2? Why not crack it open and have a look at where the DC-in socket connects to the mainboard. It might have a bad joint, easily fixed though.
You can see the repaired unit in the photo gallery under Sega Mega Drive Model 2 430672435.