TRANS WILL GO TO LIMP MODE. WILL NOT RESET WITH SEVERAL ATTEMPTS OF TURNING THE IGNITION ON AND OFF. IT WILL RESET AFTER ENGINE IS OFF FOR AN EXTENDED PERIOD OF TIME.

Some cars require a code scanner which will read trans codes to re-set this.

There are many different systems that could cause limp mode, engine, transmission, emissions... Limp mode is a safety that allows you to get off the street and to a shop for repairs without stranding you. Usually a significant failure eg trans will not shift.

WHEN YOUR VEHICLE GOES INTO LIMP MODE IT INDICATES A PROBLEM THAT NEEDS ATTENTION CAN BE TRANS OR ENGINE TRY TURNING SWITCH OFF AT A STOP AND GO AGAIN WITHOUT HOTRODDING IT. THERE ARE TIMES WHEN WIPING AROUND DANGEROUSLY IT WILL GO INTO LIMP MODE.

IT IS GOING INTO LIMP MODE. COULD BE A TRANSMISSION ERROR. THE LIMP MODE IS DESIGNED TO PROTECT TRANS AND ENGINE FROM FURTHER DAMAGE

watch this video Transmission No Shift Case Study P0888
other code is because the other code is still active.

Go to an Autozone, Advance, or O'reilys for a scan. Limp home means engine problems too.

Overheating is a problem or loss of signal from an engine sensor. One thing you might try is after, and only after you get a scan is to wipe the memory.

The companion computer may have embedded info and is responding to the old "Limp signal".

Check any Vacuum lines or Vacuum dashpots which can affect powertrain controls.

Most transmissions have a limp mode, or limp-home mode.
If the driveline computer thinks there is something wrong, it can lock the transmission into one gear, such as 2nd gear. Usually reverse will also be available. The Impala automatic has 4 speeds. 2nd speed or gear will get you home, but the engine rpms can get a little high. I wouldn't get on the expressway will in limp mode.
Before taking to the shop, you might want to try and reset limp mode by turning the car off for a couple minutes, or you may have to disconnect and reconnect the battery.

This usually points to a sensor issue or a computer failure.

What diagnostics have been done with a diagnostic data scanner. If its in limp mode what codes did you have before and what codes do you have now. ??

And what year vehicle are we talking about here??

the check engine light will be on 

you have to change the solenoid control if your car is 3.5 engine the solenoid control located at inside the transmission..