Sex should feel good
should feel good, not painful.
If it's painful, then something's not right. Perhaps position was wrong, etc. Otoh if this is only 2nd attempt, more likely you & your partner aren't prepared or mature enough (sorry to be so rude) since your partner should take his/her time to make sure you're ready so that sex is enjoyable, not painful. Ps don't forget to make him wear a condom to prevent stds.