Sounds like you don't have an Execution account setup, and the SSRS service is setup to run under a local account, and the report is setup to use the Windows Auth of the person running the report to log into the database.
Try setting an Execution Account within the SSRS Configuration Manager.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.