Your fiance sounds like he needs to pull his head out of his ass and respect your boundaries.

Sex doesn't need to have an anal aspect to be fulfilling. If it's something he's so hell bend on I would suggest for him to let you have a go on him with a strap on and then you'll reconsider things

Edit: your body, your rules - don't ever forget that