Re: Trusted sql connection failure
From: Ken Schaefer (kenREMOVE_at_THISadopenstatic.com)
Date: 02/14/05
- Next message: nilapenn: "Re: Using LogonUser API in ASP.net with an account other than ASPNet account"
- Previous message: Chris Rolon: "Re: Forms login and expired accounts !"
- In reply to: Arie: "Trusted sql connection failure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 14 Feb 2005 14:34:58 +1100
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
- Next message: nilapenn: "Re: Using LogonUser API in ASP.net with an account other than ASPNet account"
- Previous message: Chris Rolon: "Re: Forms login and expired accounts !"
- In reply to: Arie: "Trusted sql connection failure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
