Lounger-Master
asked on
Maximizer SQL Password Reset
I have lost the password for the Master account in Maximizer. I have found this online
http://cinchnetworks.blogspot.ca/2011/08/recovering-from-lost-master-password.html
but I am stuck at this step:
WHERE Record_Id IN
(SELECT Record_Id FROM dbo.ADMN_Users
WHERE User_Id='MASTER')
I am very savy with computers but I am not with SQL sadly. Can anyone help me go through with this?
http://cinchnetworks.blogspot.ca/2011/08/recovering-from-lost-master-password.html
but I am stuck at this step:
WHERE Record_Id IN
(SELECT Record_Id FROM dbo.ADMN_Users
WHERE User_Id='MASTER')
I am very savy with computers but I am not with SQL sadly. Can anyone help me go through with this?
ASKER
I did run the line s in this order:
1. ALTER LOGIN MASTER WITH PASSWORD='CONTROL'
2. USE SalesDatabase
3. UPDATE dbo.ADMN_Users1 SET [Password]=''
4. WHERE Record_Id IN (This one doesnt work as I think I need to select something for IN?)
Does line 3 clear the password? Should I have put a password in where it says Password in line 3?
1. ALTER LOGIN MASTER WITH PASSWORD='CONTROL'
2. USE SalesDatabase
3. UPDATE dbo.ADMN_Users1 SET [Password]=''
4. WHERE Record_Id IN (This one doesnt work as I think I need to select something for IN?)
Does line 3 clear the password? Should I have put a password in where it says Password in line 3?
> Does line 3 clear the password?
Very likely it does clear the password, and because you ran the UPDATE without a WHERE clause, set all the passwords to blank.
You can confirm with the command:
"select a.*,u.* from dbo.ADMN_Users1 a JOIN dbo.ADMN_Users u ON a.Record_Id = u.Record_Id"
which I believe will output all your user records. Unfortunately, I think you will find all the passwords now blank.
> Should I have put a password in where it says Password in line 3?
Probably not. Based on that blog, the program itself will now notice that the password is different, and will prompt you for a new password. I'd allow it to do that. (Trying to set the password to something else wouldn't really accomplish anything unless you know what encryption routine the passwords are scrambled with.)
However, once you get in as MASTER, you'll likely need to come up with a plan for the other users, possibly resetting all the user passwords.
In other words, try launching Maximizer now, and see if the rest of the blog is accurate about allowing you to log in as MASTER.
Very likely it does clear the password, and because you ran the UPDATE without a WHERE clause, set all the passwords to blank.
You can confirm with the command:
"select a.*,u.* from dbo.ADMN_Users1 a JOIN dbo.ADMN_Users u ON a.Record_Id = u.Record_Id"
which I believe will output all your user records. Unfortunately, I think you will find all the passwords now blank.
> Should I have put a password in where it says Password in line 3?
Probably not. Based on that blog, the program itself will now notice that the password is different, and will prompt you for a new password. I'd allow it to do that. (Trying to set the password to something else wouldn't really accomplish anything unless you know what encryption routine the passwords are scrambled with.)
However, once you get in as MASTER, you'll likely need to come up with a plan for the other users, possibly resetting all the user passwords.
In other words, try launching Maximizer now, and see if the rest of the blog is accurate about allowing you to log in as MASTER.
ASKER
So far I am simply not sure what to do in step 4. I have not gone any further in the article and the SQL Management Studio is open and waitng for me to complete step 4. Before I go further on this step below, what does this (SELECT Record_Id FROM dbo.ADMN_Users
WHERE User_Id='MASTER') mean for the step WHERE Record_Id IN ? The variable IN ?
WHERE User_Id='MASTER') mean for the step WHERE Record_Id IN ? The variable IN ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You so much! That did the trick!
The bad news is, if you've already run the first line by itself, you've likely cleared the password for all the admin users, i.e. set them all blank.