Connecting to a remote data source.

Hi all,

I have deployed a report onto the Report Server on a remote machine.

When i call the report an error is displayed as follows:

An error has occurred during report processing.

An error has occurred during report processing.

Cannot create a connection to data source 'MydataSource'.

For more information about this error navigate to the report server on the local server

machine,

or enable remote errors. Yet when i refresh the browser the report will be displayed. Has anyone any idea why the report will not be displayed every time a request is made ? Any help would be much appreciated! Ivan

Are you using integrated security for your data source? Most likely the issue is double-hop.

http://blogs.msdn.com/jgalla/archive/2006/03/16/553314.aspx

Connect with Access

Can someone point me in the right direction.. I want to connect to and call
either a procedure or function from accessYou can add a linked server to Access from SQL Server. For examples, see
sp_addlinkedserver, and sp_addlinkedsrvlogin in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Brian" <nixtootec@.hotmail.com> wrote in message
news:edIFt3k#DHA.2324@.tk2msftngp13.phx.gbl...
Can someone point me in the right direction.. I want to connect to and call
either a procedure or function from access