Could it be that VS is using your credentials and SSRS is using a different set? I had an issue with old SQL jobs trying to use SA and those rights would not cross to another server to create a connection. Still very much a SQL n00b, but figuring this stuff out the hard way.