Cannot create a connection to data source

I am in the same situation as many who have been getting this problem except
I have a slightly unique situation. I cannot specify credentials in my
shared connection. I am using the three tier approach without AS. I cannot
specify credentials because I want them to run a stored procedure that uses
the credentials passed in to return them only thier data, not the data of any
other user. It parses the user name using the system_user attribute to find
out who is calling the procedure and then queries the database with that
information. If I pass credentials in then everyone will see the same data,
not the result I want. I need to know how to get the credentials to pass to
the third tier. Can someone help with this...?
-Ed
Web Systems Engineer
Mercy Medical CenterThis seems to have one more wrinkle. It is only when I try to use pass
through authentication. If I switch the data source to "The credentials
supplied by the user running the report" and check the box "Use as Windows
credentials when connecting to data source." and then use the same
credentials I am logged into the computer with the report loads exactly as
expected. If I change the datasource to Windows NT Integrated Security then
the reports fails to load with an error. The error is :
"Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'src'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection. "
-Ed Mackin
Web Systems Engineer
"Ed Mackin" wrote:
> I am in the same situation as many who have been getting this problem except
> I have a slightly unique situation. I cannot specify credentials in my
> shared connection. I am using the three tier approach without AS. I cannot
> specify credentials because I want them to run a stored procedure that uses
> the credentials passed in to return them only thier data, not the data of any
> other user. It parses the user name using the system_user attribute to find
> out who is calling the procedure and then queries the database with that
> information. If I pass credentials in then everyone will see the same data,
> not the result I want. I need to know how to get the credentials to pass to
> the third tier. Can someone help with this...?
> -Ed
> Web Systems Engineer
> Mercy Medical Center
>