What are the chances of male sterility if mumps are contracted in adulthood?

Rare. Sterility is rare even in cases of bilateral orchitis. Affected testes may atrophy resulting in cosmetic imbalance, though.