I have an existing access database which I will be upsizing to a SQL Express database. The problem with my old database is that i created a members table which stored all my members passwords using MD5. Since I will be transfering all the data from the Access database into my SQL Express database, I will have 2 problems, 1) Authentication with MD5, and 2) Adding new users using MD5.
I am using the login control built in to VS.NET 2005, and have already built my pages, eg, adduser, forgotpassword, and login (using their respective controls) etc etc.
When I run the ASP.NET Configuration for my website, I've noticed that when I add users, their passwords are stored in the database using SHA1 (which I understand is the default). I have read your guidlines above, but im unable to to make it store the users passwords using MD5. Remember, I need to apply this to the built-in login control's "CreateUserWizard", and the method above seems to use a connection string as the example, which slightly throws me.
Can anyone help me here? It is not feasible to get all my users to re-register. :(
Thanks in advanced.
WizzKidd