A friend of mine has an '05 Limited coupe with auto trans. Seems the car won't always change gears. It will rev to the redline without shifting while in Drive, and does the same in auto-shift. It has thrown 2 CELs, one I remember had something to do with the speed sensor, the other something related to either the solenoids or trans fluid level. It was taken to the local dealer who wasn't any help.

My questions would start with:
Where is the speed sensor cable connection(near the wheel?)
Should the trans be serviced(dealer looked at fluid level, said it was in range)?
Any other items you can think of that could cause this?

Any and all help is greatly appreciated!