Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 7 of 7

Thread: Too many login attempts and no lost password?

  1. 11-18-2011, 01:22 PM #1
    Rabel is offline Member
    Join Date
    Jan 2008
    Posts
    65

    Default Too many login attempts and no lost password?

    Hi Guys,
    I have an issue where I had my password reset while or mail appconfig was changed and I cant use the lost password to get in. I tried using the sql method I found at

    http://manual.aspdotnetstorefront.co...-password.aspx

    But that is not working because when I hit execute I get no message like i didnt hit anything, now my host is telling me I need SQL Server Management, is there anything else I can do to get logged in.

    Randy
  2. 11-18-2011, 01:29 PM #2
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Are you talking about admin access and do you have access to your database?
  3. 11-21-2011, 12:49 PM #3
    Rabel is offline Member
    Join Date
    Jan 2008
    Posts
    65

    Default

    hi dean,
    yes im talking about admin access, and I do have access to my database. Please any help is really appreciated.

    Randy
  4. 11-21-2011, 01:21 PM #4
    Rabel is offline Member
    Join Date
    Jan 2008
    Posts
    65

    Default

    is this exactly how I should edit the admin login, so that it is back to the normal login

    Code:
    UPDATE [Customer]
     SET [Password] = 'Admin$11',
           [SaltKey] = -1,
           [LockedUntil] = DateAdd(mi, -1, GetDate()),
           [BadLoginCount] = 0,
           [PwdChangeRequired] = 0,
           [PwdChanged] = GetDate()
     WHERE [Email] = 'admin@aspdotnetstorefront.com '
  5. 11-21-2011, 04:26 PM #5
    Rabel is offline Member
    Join Date
    Jan 2008
    Posts
    65

    Default

    OK I have downloaded SQL Server Management Studio 2008 but I am not sure how to get it to connect so I can run the query needed to reset the password.


    under file I have "connect object explorer"
    then "database engine" or "SQL Server Compact Edition"
    Please let me know how I can connect to the database.

    I have been trying to get into this for a while now and I have a meeting at 9am tomorrow morning, if there is anything that can be done to help me get into this.
    If I cant get in I know they will be switching to a different commerce option, eventhough I am a fan of aspdotnetstorefront. Please Help.
  6. 11-22-2011, 02:07 AM #6
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Ok firstly to connect open up SQL Management Studio then use Windows Authentication as the authentication type.

    If it asks you for a username you should be able to find this under IIS Manager. It will be the first thing you see under start page. (ID0000/userexample)

    Once thats done click connect and let me know if you can get in.
  7. 11-22-2011, 02:52 PM #7
    Rabel is offline Member
    Join Date
    Jan 2008
    Posts
    65

    Default

    Thanks for your help, I was able to get my host to help and using the code above with my address i was able to get in. Thanks.