None of my users can log in after database modification

Discussion in 'Databases' started by DZL, Dec 1, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. DZL

    DZL

    I made some changes to a table in a MS SQL 2005 database on my local computer, then uploaded to the server, and used the Attach Data File tool to overwrite the old one.

    Everything worked fine (the table change went through, no apparent loss of data) except, users can no longer log in with their user name and password. I am using the MembershipUser Class of ASP.NET 2.0 to manage my users. I wonder if it has anything to do with the password hash/encryption, and if there is anything I can do. I don't want to wipe out all my users anytime I update my database.
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    >>I wonder if it has anything to do with the password hash/encryption, and if there is anything I can do.

    I don't think that matters.

    Do you get any exception or it just give you an invalid username /password error?

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. DZL

    DZL

    No exception or error. Just said user name and password not recognized.
     
  4. I dont think hash/excryption should cause that.Did you make changes to aspnet membership tables?

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  5. DZL

    DZL

    I thought that another topic was relevant to this problem, specifically "Attaching SQL2005 DB." You actually solved this problem for me in that thread. I was downloading the database in the App_Data folder, and when I ran it on my machine, none of the users who had signedup onlinewere in that database. Now I know I have to use the backup utility, and download the .bak file. Thanks again for helping me out with this.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page