Don't be a YES man
As a consultant, you try to do whatever the client is asking. However, you need to manage expectations. Don't say something can be done or you can deliver in x amount of time if it is just not feasible. Down the road this will become a point of contention. Manage expectations upfront. Be honest with your clients. They may not like the answer, but they will appreciate not wasting their time or money.