Are you using the same user? if Yes, try with JDBC client tools like SquirrL and see if you connect and see the tables from the same machine. If you do not see there then there is issue with user/driver etc., if you see the tables but not in Designer then there is some issue needs to be further investigated.
Thanks Ramesh for the help. There was an issue with the driver. Fixed now