Matthew Clifford (11/9/2010)
If the user is in IIS5 which runs in Win2k trusted for delegation is not valid because Delegation comes with Win2003 some of the reasons creating an account to use is one of the valid ways to resolve this problem.
Kind regards,
Gift Peddie
What if you are running Server 2008?
I think in Server 2008 it may still depend on the skills of the system admin, SQL Server is a member server without AD tasks and all the DC (domain controllers) are Windows 2008. One more thing Windows 2008 runs IIS7 same with Vista while Windows 2008 R2 runs IIS 7.5 same with Windows 7 there are many differences. I run IIS 7.5 the Asp.net team have Windows authentication disabled by default.