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: Installing SP4 on SQL 2000
      ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... MCITP: Database Administrator ... "David G" wrote: ...
      (microsoft.public.sqlserver.setup)
    • RE: Installing SP4 on SQL 2000
      ... As you said this is a fresh install, so it should not be an issue. ... If you are installing are installing a fresh version of SQL Server 2000, ... MCITP: Database Administrator ... "David G" wrote: ...
      (microsoft.public.sqlserver.setup)
    • 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 2008 Express + SP1
      ... Again there are three service pack setups which are provided by Microsoft. ... Are u sure you are using correct version for your install? ... DB Dev SQL Server 2005 ... Script level upgrade for database 'master' failed because upgrade step ...
      (microsoft.public.sqlserver.setup)