My husband used to have the same problem! Turns out he has sleep apnea. The sleep apnea causes him to sweat a lot while he sleeps because his body is working so hard to breathe. The sweat was also more stinky than usual sweat because of chemical changes that were going on in his body during the sleep apnea. Now he's on a CPAP sleep machine and no longer has this problem. He also feels better than he ever thought he could, now that he is experiencing REAL sleep. I suggest you go get tested at a sleep clinic. It's really easy, they just put some stickers on your skin to monitor your oxygen levels and you go to sleep.
Sleep apnea is a serious problem if left untreated and leads to other problems like heart disease, high blood pressure, and early death. It's a silent killer. If untreated it will slowly ruin your life.
Unfortunately deodorants won't help.