I am working with a windows server 2003,SQL SERVER 2005 and Reporting Services.
Basically, SQL Server is on my local machine and the Reporting Services Server is on another computer.
When I have tested my my reports on the local machine there is no error.
But when I'm deploying them on the new Reporting Services Server using another machine. 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)'.
So the reason is not associated with a trusted SQL Server connection. "
Generally this error occurs 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 get this error message.
I've found some people talking about a "double HOP" problem. :ermm:
But I'm not an expert in Security or in Network Connection problems.
Is that someone already had the same error?