You can simply run this command on Server - 2003 & 2008 R2 editions to get the Users Romaing profile SID.
wmic useraccount where name='username' get sid
Say enter, once type this in command line.
There are couple of other Links related to User profile Issue, as below
Thanks for your time
Happy to help