Re: ASPNET MSDE account login failure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tarundeep Singh Kalra (tkalra)
Date: 05/06/04 

Date: Thu, 6 May 2004 19:34:25 +0530

give appropriate rights to ASPNET user. 

-- 
Tarun
**********************************************************************
Tarundeep Singh Kalra
(tarundeep1976_nospam_at_yahoo_dot_nospam_dot_com)
tarun_at_tarunsadhana_dot_com
visit:
www.tarunsadhana.com
*************************************************************************
"Paul C." <jaco@jacostacos.com> wrote in message
news:bnjmc.5752$qc2.128@newssvr24.news.prodigy.com...
> Thank you, Tarundeep.  I have tried that, but it does not help me.
>
> My regedit shows this under HKEY_LOCAL_MACHINE | SOFTWARE | Microsoft |
> Microsoft SQL Server | VSdotNET | MSSQLServer:
> AuditLevel = 0
> DefaultLogin = guest
> ListenOn = SSMSSH70 SSNETLIB
> LoginMode = 1
> Map#=-
> Map$=
> Map_=\
> SetHostName=0
> Tapeloadwaittime=0xffffffff
>
> I tried setting LoginMode=2, but I still get a login failure for
> MARS\ASPNET.
>
> From looking at the above settings, can anyone tell if I'm missing
> something?
>
> When I installed MSDE, I logged in as paul, a member of Administrators
> group.
>
> Also, any comments (or web pages) as to what the keys means would be much
> appreciated.
>
> Rumor has it that the MSSQL Server developer's edition is for sale at Frys
> for $50.  I'm thinking of getting that, just for the tools so I figure
what
> in the heck is going on w/my SQL Server instance.
>
> Thanks.
>
> Paul C.
>
> "Tarundeep Singh Kalra" <tkalra at gric dot com NOSPAM> wrote in message
> news:uwl3PUSLEHA.3596@tk2msftngp13.phx.gbl...
> > change MSDE settings to mixed mode.
> > go to registry key
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> > change LoginMode to 2
> > -i hope it helps
> > -Tarun
> >
> > -- 
> > Tarun
> > **********************************************************************
> > Tarundeep Singh Kalra
> > (tarundeep1976_nospam_at_yahoo_dot_nospam_dot_com)
> > tarun_at_tarunsadhana_dot_com
> > visit:
> > www.tarunsadhana.com
> >
*************************************************************************
> >
> >
> > " Gerry O'Brien [MVP]" <gkcomput@hotmail.com> wrote in message
> > news:OxCrjNuKEHA.1144@TK2MSFTNGP12.phx.gbl...
> > > Your login failure appears to be a result of a failure on MSDE and not
> > IIS.
> > > You need to ensure that the account accessing the MSDE engine has a
> login.
> > >
> > > Are you using SQL, Windows or integrated login?
> > >
> > > I haven't used MSDE so I'm not sure if it gives you the option when
you
> > > install it.
> > >
> > > -- 
> > > Gerry O'Brien
> > > Visual Developer .NET MVP
> > > Visual Basic
> > >
> > >
> > > "Paul C." <jaco@jacostacos.com> wrote in message
> > > news:YRqic.1195$Q_.672@newssvr24.news.prodigy.com...
> > > > Hello, everyone.  I am getting this message when I try to fill my
> > > > SqlDataAdapter using MSDE:
> > > > Login failed for user 'MARS\ASPNET'.
> > > >
> > > > (Mars is my machine's name).  I know asp.net uses the ASPNET account
> to
> > > > work, but I'm mystified as to why this is suddenly not working.
Does
> > > anyone
> > > > have any ideas on what to try, tools to use to see what's going
wrong?
> > I
> > > > have my MSDE instance running under Local Account, and my account <-
> > > > Administrators group, VS Developers and Debuggers, so that should do
> it.
> > > >
> > > > Incidently, my datagrid is not showing up, but my Server control
> button
> > > is.
> > > > Last time that happened, I just did a 'aspnet_regiis -i', but that
> > doesn't
> > > > help this time.   Please help.
> > > >
> > > > Paul C.
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>
Quantcast