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" <> wrote in message
news

D45121B-BDBC-4F57-90D1-...
> 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