Found out how to get it to work.

Set the FoxPro OLE DB Credentials to a network account which has access to the FoxPro Data.
In IIS tick the Anonymous Access and use the same account as above for both Reports and ReportServer directories.
Restart IIS.

Job is a good one.