Hi, I've SQL server 2008 roduct version:10.0.1600.22,Resource ver:10.00.1600,RTM,Developer Edition. Made a report server project with dataset connected to another SQL server(2005) to get the data. I'm using Integrated security for the connection. Deployed onthe 2008 RS.It is working fine until I try to run it from different PC,alsologged intoDomain with same domainuser. RS are using the samedomainuser with administrative credentials to start. I recieved the following error from the webservice: An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source 'DataSource'. For more information about this error navigate to the report server on the local server machine, or enable remote errors And there is an error logged into the reporting service log file: "processing!ReportServer_0-1!d80!09/23/2008-16:01:53:: e ERROR: Data source 'DataSource': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.processing!ReportServer_0-1!d80!09/23/2008-16:01:53:: e ERROR: An exception has occurred in data source 'DataSource'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.processing!ReportServer_0-1!d80!09/23/2008-16:01:53:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...processing!ReportServer_0-1!d80!09/23/2008-16:01:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." The report is working only if I change the property of the datasource ("Credentials stored securely in the report server"). Why the report does not use the integrated security, to connect to another sql,instead of using anonymous login.Can anyone help to solve the problem?

In order to connect to a remote SQL Server instance and pass the user's credentials you would need to have Kerberos setup in your environment to pass the token properly. If this is not enabled in your environment then you will need to look at using SQL Authentication or specify the credentials of the user to connect or set this up to prompt the user for credentials. You can take a look at the Deployment Guide for PerformancePoint Server for additional information for configuring SSRS and for enabling Kerberos. Deployment Guide for PerformancePoint Server 2007 Download

Thank you, I'll try. For now I'm using alinked server to connect to remote server.

The solution I Tried and solved Error message in Oracle data source "System.Exception: OCIEnvCreate failed with return code -1 but" the problem is Report server application can't access aspnet temp app. directory. the solution is in belove http://technet.microsoft.com/en-us/library/bb418935.aspx Unable to access reports on a remote reporting server After installation of SQL Server Reporting Services, an attempt to access the remote Report Manager might result in the following message: "The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\Windows\Microsoft.Net\Framework\v2.0.50727\Temporary ASP.NET Files.'" Background This issue may occur on topologies with remote MOM reporting servers. Solution To resolve this problem, you must explicitly grant network service write permissions to the .NET Framework folder on the remote MOM reporting server. To grant write permissions to the .NET Framework folder Open the following folder: C:\Windows\Microsoft.Net\Framework\ v2.0.50727\Temporary ASP.NET Files Right-click the folder and click Sharing and Security . Click the Security tab and click Add . In the Enter the object names to select box, type Network Service , and then click OK . Under Allow , ensure that the Read & Execute , List Folder Contents , and Read check boxes are selected. Under Allow , select the Write check box, and then click OK . In the warning message that appears, click Yes .