I don't understand the comments above that the CEO's job is to be effective and not liked. They aren't mutually exclusive.
Edit: If anything, the two qualities can be symbiotic.
That's a little naive. How often do you hear "three cheers for the referee" or "our HR are really great"?