Last post Jun 18, 2007 02:16 PM by Navadia
Jun 17, 2007 04:50 PM|johntboyle|LINK
I changed the password for the MS SQL DB on Godaddy, big mastake.
Anyway I had to change the Webconfig file to show the new password finally got the PWS site back but and running.
However I can't logon to any of the users I had previously setup and I don't want to start again or loose my pictures.
I do not know how to use SQL or the godaddy interface to well so I don't know how to reset the passwords.
I can see the four users I set up but the passwords are encripted and I can't leave them blank?
Jun 17, 2007 06:13 PM|Navadia|LINK
Do you have remote access to the SQL database?
If so it'll take a few seconds to get you up and running.
Jun 18, 2007 01:58 PM|johntboyle|LINK
Yes I have remote access. I don't know how to update.
A work around I used was use the following script: But this was to setup new users. I don't know how to update
SET @userName = 'YOUR_USERNAME_HERE'
SET @userID = (SELECT TOP 1 UserId FROM aspnet_Users WHERE UserName = @userName)
UPDATE aspnet_Membership SET IsApproved = 1 WHERE UserId = @userID
SET @roleID = (SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators')
INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES (@roleID, @userID)
Jun 18, 2007 02:16 PM|Navadia|LINK
Create a new user using the the register feature on the site.
Then open up the dbo.aspnet_Users and change the False to True this will allow the user name to log in.
Open the dbo.aspnet_Roles Get the info for the admin role and then open dbo.aspnet_UsersInRoles and input the admin info to the new user you just created. Once done you should be able to login as a admin. You can delete old members and re register them.