But the answer is right in the log. The user doesn't have access to the server.

Try adding them and see what happens, do it on a test machine first...

I've had similiar issues, check to make sure that your service account is part of the Local Admins of the machines. If not then that account must have the following...

I made some other changes that made this work a little better for me, hopefully it helps.

Biggest thing that I did notice was that the [Default Database] was set to...

I got the same errors, but when I retyped out the commands it worked fine.

OK that does make sense because I have the DBA_Rep on another server altogether from the SSRS instance.

Well in my case, its not because its Express, it is the Standard install of SQL2005 with Reporting Services and the tests all work fine when previewing from Visual Studio,...

I did try that and still getting the same problems. :crazy:

I'm still getting the "Cannot create a connection to data source 'test' " error message even though I have changed the DataSet2 to be a Stored Proc.

I've only added...