Ok I need some help. Up until Tuesday my application was working fine.
It is an asp.net application written in VB. It is very data heavy and
makes multiple calls to a database. The application itself sits on an
IIS6.0 server. And the database is on an SQL2000 server with SP 3a.

On Tuesday we started getting an error when we tried to call up the
application. It said: Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.

The IIS server settings for the application are set to Windows
Authentication only

The web.config setting are as follows:

<identity impersonate="true" />

<authentication mode="Windows" />

<deny users="?" /> <!-- Allow all users -->

<sessionState mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data
source=127.0.0.1;Trusted_Connection=yes" cookieless="false"
timeout="20" />

And the connection string is: "data source=myserver;initial
catalog=myDatabase;Integrated Security=true"

I thought I was fine, I thought that I had a trusted connection set up
between the IIS server and the SQl server. Am I missing something here?
I think I have tried almost everything I have read about. Anybody have
any ideas? Thanks for your help.

this is a classic ASP newsgroup. Your need to ask this in an ASP.NET
newsgroup if you want to get a good answer


<jerminator [at] gmail.com> wrote in message
news:1134163320.929094.229280 [at] g43g2000cwa.googlegroups.com.. .
> Ok I need some help. Up until Tuesday my application was working fine.
> It is an asp.net application written in VB. It is very data heavy and
> makes multiple calls to a database. The application itself sits on an
> IIS6.0 server. And the database is on an SQL2000 server with SP 3a.
>
> On Tuesday we started getting an error when we tried to call up the
> application. It said: Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection.
>
> The IIS server settings for the application are set to Windows
> Authentication only
>
> The web.config setting are as follows:
>
> <identity impersonate="true" />
>
> <authentication mode="Windows" />
>
> <deny users="?" /> <!-- Allow all users -->
>
> <sessionState mode="InProc"
> stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data
> source=127.0.0.1;Trusted_Connection=yes" cookieless="false"
> timeout="20" />
>
> And the connection string is: "data source=myserver;initial
> catalog=myDatabase;Integrated Security=true"
>
> I thought I was fine, I thought that I had a trusted connection set up
> between the IIS server and the SQl server. Am I missing something here?
> I think I have tried almost everything I have read about. Anybody have
> any ideas? Thanks for your help.
>