There are layers to being liked:

1. Are you nice and pleasant around people? Always do this.
2. Are you agreeable and easy to work with? It really depends on you and the job, but here you have to be smart.
3. Do people respect you? You have to be honest and good at what you do, while keeping a careful balance of the second point.

Balance is hard and sometimes you may just find out that the issue might be that workplace do not deserve you and you need to move on.