Go rent the original Muppet Movie. It’s the best of the Muppet ouvre, really. Rainbow Connection is near the beginning of the film (it may be at the very beginning – it’s been a while since I’ve watched it).