Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 25-10-2008
Member
 
Join Date: Jul 2006
Posts: 339
login failure in ASPNET MSDE account

Hello, guys 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.
Reply With Quote
  #2  
Old 25-10-2008
Member
 
Join Date: May 2008
Posts: 2,008
Re: ASPNET MSDE account login failure

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.
Reply With Quote
  #3  
Old 25-10-2008
Member
 
Join Date: May 2008
Posts: 2,293
Re: login failure in ASPNET MSDE account

change MSDE settings to mixed mode.
go to registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer
change LoginMode to 2
Reply With Quote
  #4  
Old 25-10-2008
Member
 
Join Date: Jul 2006
Posts: 339
Re: login failure in ASPNET MSDE account

Thank you, Zecho. 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.
Reply With Quote
  #5  
Old 25-10-2008
Member
 
Join Date: Nov 2005
Posts: 1,323
Re: login failure in ASPNET MSDE account

On your computer there is an ASPNET account. Your message is due to the fact that this account, which is used when invoking aspx pages does not have access neither to MSDE nor to the DataBase of your computer.
You must grant authorization to this account to do that On Command Prompt introduce these orders :
osql -E -Q "sp_grantlogin 'COMPUTER_NAME\ASPNET'"

osql -E -d databasename -Q "sp_grantdbaccess 'COMPUTER_NAME\ASPNET'

Where computer name is your computer name, databasename is your database name.
ALternatively you can enter an order in your Web.config file
<identity impersonate="true" userName="accountname" password="password" />
where the username corresponds to a user that has access to this database, but this is less secure.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "login failure in ASPNET MSDE account"
Thread Thread Starter Forum Replies Last Post
Crysis multiplayer login failure in Windows XP Robert Beck Video Games 4 22-05-2011 10:17 AM
Login Failure in yahoo mail on AINO. Mrigankasekhar Portable Devices 4 17-04-2010 11:58 PM
FTP login failure issue Galbraith Networking & Security 5 14-03-2010 02:37 AM
You might not have permission to use this network resource. Login failure zillah Windows XP Support 1 20-01-2009 03:27 AM
login failure janice blake Operating Systems 1 20-08-2008 02:23 PM


All times are GMT +5.5. The time now is 08:06 AM.