If you receive:

Failed getting User Configuration, Error = 2 (0x2)
when using TSPROF to modify the profile path, chances are that you did not use Terminal Server User Manager to create the account, but used the NET USER or Windows NT User Manager.

Modify the profile path using Terminal Server User Manager. Once you do this, TSPROF will function on subsequent attemps with this account.