The account used to access data is the one in data sources not the service or app pool account. You can make sure the account is right and has permission by using SQL Reporting configuration tool.

Hope this helps.