> Sqlserver 2000/sp3a on Windows 2003
> IIS 6.0 on Windows 2003 (seperate servers)
>
> I'm getting application eventlog error 17055 (mssqlserver) entries and
> also in the sqlserver log saying Login failed for user '(null)'. Reason:
> Not associated with a trusted SQL Server connection.
>
> Generated by running an asp script on an IIS 6 website. IE displays the
> following error: The connection cannot be used to perform this operation.
> It is either closed or invalid in this context. Error Number 3709 Error
> Source ADODB.Command
>
> Configured IIS to use anonymous access only, using a domain account.
> Created sql login for that domain account and granted it access to the
> database on the sqlserver. Both servers are in the same ADS domain, both
> are running Windows 2003. The asp connect statement includes
> "Provider=SQLOLEDB;trusted_connection=yes;integrated security=sspi".
> Sqlserver network config has named pipes and tcp/ip enabled.
>
> Any ideas what is causing this error?
> -Frank
> http://www.inwa.net/~frog/
>

> Any ideas what is causing this error?