• And Here is the possible fix I have come to know...

    DBA has elevated privileges for service account being used for SSRS

    Thanks