Authentication problem

Hi, all,
I am using SQL Server 2000 SP3 and Windows 2000 Server Sp4.
IIS Server is running on Server A.
SQL Server is running on Server B.
Web Application on Server A will connect to SQL Server on Server B, I want
to use Windows Authentication Mode. How can I do this?
Thanks in advance.
kevinHi, all:
I have found the answer in this news group, on 3-23, raise by Timo, subject
is
<<IIS -> SQLServer on another machine>>.
But now my problem is that: this way doesn't work in Crystal Reports!
Do anyone have any ideas?
Thanks
kevin
"Kevin Dai" <kevin_dzy@.hotmail.com> д?
news:eviJfcfFEHA.3576@.tk2msftngp13.phx.gbl...
> Hi, all,
> I am using SQL Server 2000 SP3 and Windows 2000 Server Sp4.
> IIS Server is running on Server A.
> SQL Server is running on Server B.
> Web Application on Server A will connect to SQL Server on Server B, I want
> to use Windows Authentication Mode. How can I do this?
> Thanks in advance.
> kevin
>|||What's the exact error you get? And is it really specific to Crystal
Reports or does it happen from any 3rd machine? You may be having a
double-hop problem (where IIS can talk to SQL, but a workstation that uses
IIS to talk to SQL has to use Kerberos delegation to pass the workstation's
credentials through IIS to SQL).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.