ASP.net page with Crystal Report using Integrated Security

Using a simple ASP.net page with a crystal report on it. Loading from
IIS using Integrated Secruity in the reports connection string it
populates the report in the browser.

What User ID and password is Crystal Report using to get permission to
access the database?

I created a simple ASP.net page with a data grid using integrated
security. It gives an error that it's not a trusted user.

My understanding is the IUSR user ID and password must be on the domain
and on the SQL server to get the data but how is the Crystal Report
working?

In other words how is IIS 5.1 be getting data for a Crystal Report but
can't for a data grid.

Re: ASP.net page with Crystal Report using Integrated Security

wrote on 04 jan 2007 in microsoft.public.inetserver.asp.general:

> Using a simple ASP.net page with a crystal report on it. Loading from
> IIS using Integrated Secruity in the reports connection string it
> populates the report in the browser.
>
> What User ID and password is Crystal Report using to get permission to
> access the database?
>
> I created a simple ASP.net page with a data grid using integrated
> security. It gives an error that it's not a trusted user.
>
> My understanding is the IUSR user ID and password must be on the domain
> and on the SQL server to get the data but how is the Crystal Report
> working?
>
> In other words how is IIS 5.1 be getting data for a Crystal Report but
> can't for a data grid.
>
>

This is a classic asp group.

asp.net questions c/should be asked in


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Re: ASP.net page with Crystal Report using Integrated Security

in addition to Evertjan's response:

Under ASP the Crystal Reports web engine requires that the connection string
either be embedded in the report definition or set in the script which
creates the report engine object. That is probably the same in .NET.

--
--Mark Schupp


wrote in message
news:1167947608.869569.27760@51g2000cwl.googlegroups.com...
> Using a simple ASP.net page with a crystal report on it. Loading from
> IIS using Integrated Secruity in the reports connection string it
> populates the report in the browser.
>
> What User ID and password is Crystal Report using to get permission to
> access the database?
>
> I created a simple ASP.net page with a data grid using integrated
> security. It gives an error that it's not a trusted user.
>
> My understanding is the IUSR user ID and password must be on the domain
> and on the SQL server to get the data but how is the Crystal Report
> working?
>
> In other words how is IIS 5.1 be getting data for a Crystal Report but
> can't for a data grid.
>