IIS (asp.net 2.0):: logon failure

From: Ed Warren (eowarren_at_fakeaddress.zzz)
Date: 11/18/05 

Date: Fri, 18 Nov 2005 09:07:56 -0600

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.

Relevant Pages

  • Re: Internet Information Services in MCE
    ... Per user Group Policy Restrictions for XP Home and XP Pro ... However, I am able to run SQL Server Dev Edition on my work laptop, which is ... I've installed the IIS component but I'm not sure I have a good ... I'm trying to install SQL Server 2005, ...
    (microsoft.public.windows.mediacenter)
  • Re: SQL Server 2005 Express Adv. Edition Installation error 2259:Database table(s) update failed
    ... When I try to install SQL Server 2005 Express Adv. ... Steps to Reproduce:Either Windows install or manual install creates the error. ... Microsoft Internet Information Services (IIS) is either not installed or is disabled. ... some SQL Server features will not be available for installation. ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing Reporting Services
    ... IBIS must be on the same physical machine as Reporting Services. ... SQL Server Manageability Platform Team ... Microsoft seem to advise against having a SQL Server and IIS on the same ... seems that IIS is required on the local SQL box in order to Install / ...
    (microsoft.public.sqlserver.setup)
  • Re: Install 2005K on Vista missing IIS Error
    ... Install IIS with all options installed. ... IIS is required by some SQL Server features. ... Server features will not be available for installation. ...
    (microsoft.public.sqlserver.setup)
  • Re: Internet Information Services in MCE
    ... Information Services dialog box. ... Yes in the Local column and IIS V5.0 in the Version ... preventing me from installing SQL Server Developer Edition Reporting ... I'm trying to install SQL Server 2005, ...
    (microsoft.public.windows.mediacenter)