Security, Initial Catalog is the database where the stored procedure
is. The stored procedure selects data from a different database on the
server. This server is running SQL Server 200 sp2 (so
pre-Cross-Database-Ownership Chaining option). The users can execute
the stored procedure fine so it does not seem to be a permissions issue
to the data. The Report runs fine FROM the Report Server. But, if I try
to run the report from a different machine, I get:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSourceNameIsHere'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
The report also runs fine if we don't use Windows Integrated Security.
The report runs fine if the datasource (both databases) are on SQL2000
sp3. Is there anything that we can do to get this working on SQL2000
sp2? I'm not sure that all systems on this server are supported on sp3
(3a or 4). It hosts several databases from purchased products.I found this in the Reporting Services Log:
ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'DataSourceNameIsHere'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSourceNameIsHere'. > System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Michelle
