The main acid in human sweat is lactic acid. It's produced during intense physical activity when your muscles break down glucose for energy. Lactic acid, along with water, minerals, lactate, and urea, is released through sweat glands.
While sweat itself doesn't have an odor, the breakdown of lactic acid and other components by bacteria on the skin can contribute to body odor.