I'm Belgian, so I'm sorry if my English is not very good. ;-)
I'm working with a windows server 2003,SQL SERVER 2005 and Reporting Services.
The SQL Server is on my local computer and the Reporting Services Server is on another computer.
When I test my reports on the local computer there is no error.
But when I'm deploying them on the new Reporting Services Server (on another computer) .
I receive this error message :
"An error has occurred during report processing. (rsProcessingAborted).
Cannot create a connection to data source .(rsErrorOpeningConnection)
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. "
The error occur when I use the "windows authentication" with my connection string.
If I use the "SQL Server authentication" withe User Name and Password.I don't have the error message.
I've found some people talking about a "double HOP" problem.
But I'm not an expert in Security or in Network Connection problems.
Is that someone already had the same error?