Trusted sql connection failure

[Arie]

Hi all

I have a asp.net application, developed in Beta 2. It is working fine when
the project is stored in a web file system mode. I had to switch to work in a
local IIS mode, and at this mode I'm failing to connect to the database
(MSSql). This is the message in the SqlException: Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.

Thnx
AZ

[Ken Schaefer]

Is the SQL Server located on a different machine to the IIS webserver? If
so, you probably need to run ASP.NET under a domain account (or find some
other way of sending the credentials from IIS -> SQL Server). At the moment
it appears that you are running ASP.NET under a local account (either
Machine\ASPNET or NT AUTHORITY\Network Service) and local accounts can't be
assigned permissions to remote resources.

Cheers
Ken

"Arie" <Arie@discussions.microsoft.com> wrote in message
news:DD45121B-BDBC-4F57-90D1-BA8D3EFA24A4@microsoft.com...

> Hi all
>
> I have a asp.net application, developed in Beta 2. It is working fine when
> the project is stored in a web file system mode. I had to switch to work
> in a
> local IIS mode, and at this mode I'm failing to connect to the database
> (MSSql). This is the message in the SqlException: Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
>
> Thnx
> AZ