Earthward Bound (STO)
From Trekipedia
Stardate Unknown: Fleet has promoted Captain Garrett to admiral, and at his recommendation, you are now the captain of the Pioneer.
Fleet promoted me to admiral. I'll be working with Deep Space Command on several exploration initiatives there. Our ship's going to need a new captain. I've talked it over with Command, and they agree with my recommendation - you.
Congratulations, my friend. I know the ship will be in good hands once I'm away. Don't think you've gotten rid of me, though. I plan on keeping you plenty busy out there!