Stargate Atlantis Season 4 Episode 4

During an off-world mission Colonel Sheppard unknowingly becomes host to an alien entity, which infects others in Atlantis and afflicts them with terrifying nightmares.