IIS connect to SQL Server with "null" account.

Hi all, my team has implemented web applications that running on Windows 2003
and IIS6.0 querying data from SQL 2000 Server. The IIS has Integrated Windows
Authentication setting for user authentication. The web will query user data
from SQL 2000 base on user authenticate. Normally the applications are
working fine but sometimes when users logged on to page they get an error
"Object not set to an instance of an object". After checked on a detail of
the error, we found the the IIS send "NULL" account to SQL server for
querying a data. Could you all please help us solving this problem?

Re: IIS connect to SQL Server with "null" account.

That would probably indicate that Kerberos delegation is not working
properly. Check security event logs for Kerberos related failures.

Cheers
Ken

"Karn" wrote in message
news:8BFB8F67-8706-4DB9-866A-93071909CE4C@microsoft.com...
: Hi all, my team has implemented web applications that running on Windows
2003
: and IIS6.0 querying data from SQL 2000 Server. The IIS has Integrated
Windows
: Authentication setting for user authentication. The web will query user
data
: from SQL 2000 base on user authenticate. Normally the applications are
: working fine but sometimes when users logged on to page they get an error
: "Object not set to an instance of an object". After checked on a detail of
: the error, we found the the IIS send "NULL" account to SQL server for
: querying a data. Could you all please help us solving this problem?
:

Re: IIS connect to SQL Server with "null" account.

thanks for your reply. I have checked event log on domain controller. No
Keberos related failures found. what should I do next.

"Ken Schaefer" wrote:

> That would probably indicate that Kerberos delegation is not working
> properly. Check security event logs for Kerberos related failures.
>
> Cheers
> Ken
>
> "Karn" wrote in message
> news:8BFB8F67-8706-4DB9-866A-93071909CE4C@microsoft.com...
> : Hi all, my team has implemented web applications that running on Windows
> 2003
> : and IIS6.0 querying data from SQL 2000 Server. The IIS has Integrated
> Windows
> : Authentication setting for user authentication. The web will query user
> data
> : from SQL 2000 base on user authenticate. Normally the applications are
> : working fine but sometimes when users logged on to page they get an error
> : "Object not set to an instance of an object". After checked on a detail of
> : the error, we found the the IIS send "NULL" account to SQL server for
> : querying a data. Could you all please help us solving this problem?
> :
>
>
>