You trying to use General MIDI output? Playing GM in Sonar is weird, I find you have to select MME drivers (WDM is the default). Then once you exit and come back, Microsoft GM Synth (or something) should be available as an audio output.
Otherwise, you have to patch MIDI tracks to corresponding synths or samplers for them to work.