A fanfare was a short, loud piece of music that was typically played on brass instruments, such as trumpets or French horns, to announce the arrival of someone important or a special event.
Starfleet starships on active duty did not have honor detachments assigned to them. In 2269, Captain Kirk explained this to the Excalbian image of Abraham Lincoln when he asked where the musicians playing his fanfare were. (TOS: "The Savage Curtain")