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

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

  • Next message: Brock Allen: "Re: Form Authentication and logged in users (newbie)" 
    Date: Fri, 18 Nov 2005 09:42:00 -0600

    Thanks for your rapid response.
    I'm able to connect to the database using the sa logon via the SQL Server
    Management Studio.

    My best guess it is somewhere in the IIS setup, and the way it is trying to
    connect to the database.

    Ed Warren.

    "Dominick Baier [DevelopMentor]" <dbaier@pleasepleasenospamdevelop.com>
    wrote in message news:4580be63140a098c7ba7467d25486@news.microsoft.com...
    > 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.
    >>
    >
    >

  • Next message: Brock Allen: "Re: Form Authentication and logged in users (newbie)"

    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: Why do I need to restart the SQL service?
      ... > I use Wise Installation utility to install MSDE 2000A. ... what I do within the app is: ... Check to see if the database exists. ... > SQL Server does not exist or access denied. ...
      (microsoft.public.sqlserver.msde)
    • 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: sa password was inadvertently changed. With a kicker...
      ... Call the vendor of the new software product, and ask them what the> install script sets the SA password to when installing the product. ... Put the database files back where they should> be, ... >> I have a SQL Server 7 Standard edition server running in a ...
      (microsoft.public.sqlserver.security)
    • Re: How do i move an SQLDatabase to another location?
      ... database to a client location, install it and have it run using the ... It requires that the SQL Server service be ... client system for a single-user application or on a LAN/WAN share that's ... install it yourself during application setup. ...
      (microsoft.public.dotnet.framework.adonet)