(written from a Production point of view)
"Where My Heart Will Take Me" is the main title song of Star Trek: Enterprise. Originally titled Faith of the Heart, it was written by Diane Warren and originally performed by Rod Stewart for the 1998 movie Patch Adams. The version for Enterprise was performed by Russell Watson. It was the only Star Trek theme song besides the Original Series that was not completely an instrumental, orchestral piece.
"Where My Heart Will Take Me" was played for the crew of the space shuttle Discovery as their morning wake-up call on 2 August 2005.  The song was also used as a wake-up call for the crew of the Endeavour during STS-118 on 9 August 2007.  The song was used again for the STS-125 Hubble Telescope repair crew on board Space Shuttle Atlantis on 24 May 2009. 
It's been a long road, getting from there to here.
It's been a long time, but my time is finally near.
And I will see my dream come alive at last. I will touch the sky.
And they're not gonna hold me down no more, no they're not gonna change my mind.
Cause I've got faith of the heart.
I'm going where my heart will take me.
I've got faith to believe. I can do anything.
I've got strength of the soul. And no one's gonna bend or break me.
I can reach any star.
I've got faith.
I've got faith, faith of the heart.