locked
Lgin failed for user <XXXX\ASPNET> RRS feed

  • Question

  • User-419034929 posted

    When I test the TimeTracker i VS2005 it runs fine, but when it is published on ISS I get the error: LoginFailed For User <XXXX\ASPNET>

    I had the MDF file attatched to SQL Express Management and ran the following script:

    sp_grantlogin 'XXXX\ASPNET'
    GO

    sp_grantdbaccess 'XXXX\ASPNET'
    GO

    sp_addrolemember 'db_owner', 'XXXX\ASPNET'
    GO

    And after I detatched it again.

     I'm runninng it on XP-pro, using SQL Express.

    Somtimes It won't even show the Login.aspx, and it show the same error, then when i hit refresh It show the page. Then when i try to login, the error reappears.

     I think i't a Timeout problem but I added 'Connect Timeout=30' in the web.config connectionstring, and that didnt solve the problem.

    Monday, March 5, 2007 8:06 AM

All replies

  • User886463885 posted

    Hi,

    I suggest you try following :

    1. Go to computer management console (mycoputer>rightclick>manage)
    2. Navigate to local groups
    3. Add XXX\ASPNET in all SQL Server gorups

    Then try following

    1. Go inet mgr
    2. Check whether "Integrated windows authentication is checked"

    Reset IIS and try.

    Monday, March 5, 2007 9:35 AM
  • User-419034929 posted

    Thanks.

     Now it dosen't throw an unhandled execption. Now I just can't login on the page. But somebody else have a thread on that 'Login issue'.

    Wednesday, March 7, 2007 5:06 AM
  • User555306248 posted

    Can u post the error that you are getting ....

    It will be useful for solving the problem...

    Friday, April 20, 2007 11:55 PM