Ugh, two nights -- that's awful!
I have had some luck with Ambien and Lunesta, although I found them more useful in getting to sleep than sleeping through the night. Halcion (a benzo) made me stoned. Estazolam (another benzo) does not make me stoned, and helps a lot.
And good old Benadryl definitely makes me sleepy--but it poops out pretty quickly if you try to use it repeatedly.
Another OTC drug is Unisom (doxylamine succinate), also a sedating antihistamine. Sometimes it has worked very well for me, other times so-so.