SQL2000 through COM object hosted by IIS

[Mike]

Does anyone know of any issues logging in to a SQL 2000 Server using ADO in
a COM object hosted by IIS (deep breath)?

I'm trying to open a connection using NT authentication to a SQL 2000 database
from within a COM object under IIS and it fails everytime with the message:

"Meaning=IDispatch error #3149, Source=Microsoft OLE DB Provider for ODBC
Drivers, Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user '(null)'. Reason: Not associated with a trusted SQL Server
connection."

Which usually means the anonymous user is not setup correctly for IIS, but
it is in this case. I can connect fine to SQL 7 databases using the exact
same code, but NO SQL 2000 databases. I can connect fine to SQL 2000 databases
from an ISAPI dll using the exact same code, but not from a COM object.

Any ideas? I've updated all my drivers to the latest versions also.

[Mike]

BTW--the same COM object CAN connect to the SQL 2000 database when hosted
by another application independent of IIS.

"Mike" <mscott@scottrade.com> wrote:
>
>Does anyone know of any issues logging in to a SQL 2000 Server using ADO
in
>a COM object hosted by IIS (deep breath)?
>
>I'm trying to open a connection using NT authentication to a SQL 2000 database
>from within a COM object under IIS and it fails everytime with the message:
>
>"Meaning=IDispatch error #3149, Source=Microsoft OLE DB Provider for ODBC
>Drivers, Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Login
>failed for user '(null)'. Reason: Not associated with a trusted SQL Server
>connection."
>
>Which usually means the anonymous user is not setup correctly for IIS, but
>it is in this case. I can connect fine to SQL 7 databases using the exact
>same code, but NO SQL 2000 databases. I can connect fine to SQL 2000 databases
>from an ISAPI dll using the exact same code, but not from a COM object.
>
>Any ideas? I've updated all my drivers to the latest versions also.
>