Hey buddy -
My oldest son used to have night terrors when he was little. In his case, the solution was to take him to the bathroom, stand him up in front of the toilet, and get him to pee. After that he would sleep fine.

Give it a try.

Ellie