MS SQL Server: NT Authentication. Possible?

[Tim Golden]

[Dirk Hagemann]

| Now I found this work-around: [... snip opening restricted file ...]

| And this works! [...] So on the one hand the IIS works fine with the 
| fileserver, but the IIS does not work with the SQL-Server. And it
seems 
| not to be the fault of the code, because it works when it's executed 
| directly. It's so confusing...

(Vague handwavy answer in the hope that someone truly knowledgeable will
come across with clarifications and/or corrections). 

It's almost certainly to do with Delegation or Impersonation, 
which are fairly important aspects of the Windows security model
when it comes to distributed security but also fairly difficult to
understand (especially by me, who has never had to try...).

Try looking
at articles like:

http://msdn.microsoft.com/msdnmag/issues/05/09/SecurityBriefs/
http://msdn2.microsoft.com/en-us/library/bsz5788z.aspx

or Google around for iis sqlserver impersonation and so on.

TJG

________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________