The hippocampus is particularly sensitive to sleep loss. Although previous work has indicated that sleep deprivation impairs hippocampal cAMP signaling, it remains to be determined whether the cognitive deficits associated with sleep deprivation are caused by attenuated cAMP signaling in the hippocampus. Further, it is unclear which cell types are responsible for the memory impairments associated with sleep deprivation. Transgenic approaches lack the spatial resolution to manipulate specific signaling pathways selectively in the hippocampus, while pharmacological strategies are limited in terms of cell-type specificity. Therefore, we used a pharmacogenetic approach based on a virus-mediated expression of a G alpha s-coupled Drosophila octopamine receptor selectively in mouse hippocampal excitatory neurons in vivo. With this approach, a systemic injection with the receptor ligand octopamine leads to increased cAMP levels in this specific set of hippocampal neurons. We assessed whether transiently increasing cAMP levels during sleep deprivation prevents memory consolidation deficits associated with sleep loss in an object-location task. Five hours of total sleep deprivation directly following training impaired the formation of object-location memories. Transiently increasing cAMP levels in hippocampal neurons during the course of sleep deprivation prevented these memory consolidation deficits. These findings demonstrate that attenuated cAMP signaling in hippocampal excitatory neurons is a critical component underlying the memory deficits in hippocampus-dependent learning tasks associated with sleep deprivation.