Error when writing to SQL server through asp page using windows authentication

[Glenn M]

I have an asp drive web page that writes a row to a table on sql
server 2000. The web site is set to use windows authenication and the
sql server is set to use windows authentication.

This process works fine on windows xp sp 1 machines but on win2k sp4
machines logged in as the same user i get the error

An error occurred making the change -2147217843 Error connection to
SQL Server: [Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

can anyone explain why win2k client would have this issue and not
winxp clients?

Glenn

[Simon Hayes]

"Glenn M" <gl**********@bt.com> wrote in message
news:32**************************@posting.google.c om...

I have an asp drive web page that writes a row to a table on sql
server 2000. The web site is set to use windows authenication and the
sql server is set to use windows authentication.

This process works fine on windows xp sp 1 machines but on win2k sp4
machines logged in as the same user i get the error

An error occurred making the change -2147217843 Error connection to
SQL Server: [Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

can anyone explain why win2k client would have this issue and not
winxp clients?

Glenn

http://support.microsoft.com/?kbid=307002

If that isn't relevant, you might want to post in an ASP forum and see if
you a better answer there - it seems more likely to be an IE/IIS
authentication issue rather than an MSSQL one.

Simon