sql server reporting services: Using shared datasources in Reporting Services -- sql server reporting services

Using shared datasources in Reporting Services

afung118 NO[at]SPAM hotmail.com
8/3/2004 3:30:06 PM

sql server reporting services:

Hi,

I linked the shared data source created in Report Manager to the
report deployed to reporting services, but I'm having problem opening
the report. The shared data source is setup as such:
data source=[Database server];initial catalog=[Database name]

However, I'm getting the following error message everytime I try to
access the report.
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help Cannot create a connection to data source '[Database
server]'. (rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

Any ideas why this is happening?

Thanks,

Re: Using shared datasources in Reporting Services

Lev Semenets [MSFT]
8/3/2004 8:50:42 PM

That looks like double-hop authentication issue.
If you are using Windows Integrated Security option you may need to change
that to "The credentials supplied by the user" or "Credentials stored
securely in the report server"

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]