I need to access data on a server other than my reporting server. I have tried using the UID/PWD, tried using a linked server, stored the credientials in the data source, tried using an ole db datasource; none of this has worked for me.

When I run the report in the dev environment it runs fine but when I deploy it I get the "can't access server" error.

Any suggestions?

Thanks

Lois