Short term no, long term yes. It's uncomfortable now because you're not used to it. As you develop the back muscles necessary for good posture, you'll feel better in the long run as it'll take pressure off your spine.
Could be the chair too!
This works for me at me desk and in my vehicle.