And Hope - Sihaya Black - Stargate Atlantis [Archive of Our Own]
http://archiveofourown.org/en/works/2216?view_adult=true

While on a mission, John Sheppard discovers a device, but he doesn't expect what's inside.

The one where Rodney is a genie of sorts and Ford is back in Atlantis.

While on a mission, John Sheppard discovers a device, but he doesn't expect what's inside

"Shit!" He jumps up, dropping the shaking oval onto the bed. "What the--" His voice stops when the lines encircling the oval glow blue, and then, in a shimmer of light, like sunlit reflections on the ocean surface when viewed from below, a figure appears in front of him. "Oh, God, not again," it -- he -- mutters. Dressed in grey tunic and trousers, he's almost as tall as John but broader, with brown hair and a hairline that's heading north. His generous mouth slants down at one corner and he blinks rapidly, glancing around the room. "Where the hell . . . ." he begins, then his gaze locks on John and his mouth snaps shut. He closes his eyes, lashes brushing his cheeks, and sighs. His eyes open again, as brilliant a blue as the glow from the oval. "My name is Rodney, Master. How may I serve you?"

The one where Rodney's a genie.

Rodney's a slave trapped in an ancient device, and John wants to free him.

Sihaya Black : While on a mission, John Sheppard discovers a device, but he doesn't expect what's inside.