Is it possible to maintain sobriety while serving in any branch of the armed forces?

Does anyone attempt this? Does anyone achieve it?

Or is there too much peer pressure and/or too much pressure from the nature of the job?

Is any branch worse than the others in this respect?

Is any support offered for sobriety? Is there any help if you fail?