RepairPal Certified shops can diagnose and repair your 2003 Mercury Mountaineer. They provide transparent pricing with a minimum 12-month or 12,000-mile warranty on repairs and services.
More than likely failed low /reverse band..
Knowledgeable mechanic can quickly determine while test driving and checking for presence of manual low.
Simple but it is a very reliable test.