OK I resolved this issue. I'm able to open the Report manager URl now.

But when I try to open the reports in it says Invalid Object name 'My Table Name'. So, Then I deleted the existing report and uploaded a new RDL File and still the same error.

Can some please help on this error.