Fixed the problem after got access to the database.. Phew!
Apparently the role are not transferred over because the original hosting company changed something on the student role.
Manually added the role after restoring the course fixed this problem!
Also if you have a backend access, you can "tamper" the database with the role.