Re: IIS (asp.net 2.0):: logon failure

From: Dominick Baier [DevelopMentor] (dbaier_at_pleasepleasenospamdevelop.com)
Date: 11/18/05 

Date: Fri, 18 Nov 2005 07:29:39 -0800

Hello Ed,

are you sure mixed mode is enabled - is the only reason i can think of for
that error message.

---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

> System WinXp, running IIS, with asp.net 2.0, Visual Studio 2005,
> sqlServerExpress 2005
>
> I'm trying to install a program that builds a database via IIs. I get
> the following error when it trys to connect to the sql server
>
> "Login failed for user 'sa'. The user is not associated with a
> trusted SQL Server connection"
>
> I have verified the Sql server instance is in mixed mode.
> I have verified the account 'sa' is active and has a valid password
> (although, I would much rather not have to use it)
> I don't have enough knowledge of IIS to know where to go next to make
> the setting changes needed to install this software.
>
> Note: the sample VS 2005 remote logon (where one builds a logon page
> and 'members only' page works), so I know I can get from IIS to the
> sqlServer.
>
> Any help appreciated
>
> Thanks
>
> Ed Warren.
>