Solved

Maximizer SQL Password Reset

Posted on 2013-02-03
6
1,708 Views
Last Modified: 2013-02-06
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?
0
Comment
Question by:Lounger-Master
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 38849495
The line immediately above those three lines (UPDATE dbo.ADMN_Users1 SET [Password]='' ) should have also have been run.  (I.e. the first line you quoted above is actually line 2 of the command.

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.
0
 

Author Comment

by:Lounger-Master
ID: 38849518
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?
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 38849550
> 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.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:Lounger-Master
ID: 38849561
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 ?
0
 
LVL 30

Accepted Solution

by:
Rich Weissler earned 500 total points
ID: 38849591
Execute this:
SELECT Record_Id FROM dbo.ADMN_Users WHERE User_Id='MASTER'

It will return a single Record_ID.
That Record_ID would have matched the Record_ID in the dbo.ADMN_Users1 table which actually has the password records.  

IN is a matching condition.  In this case, the query
"WHERE Record_Id IN " is a condition of the previous line which will limit the previous line to only match records which have a Record_Id which is contained in the list of values returned in the next query.  Think of it as an equal sign, except it can match a single value against a set of values.

In that blog, these lines are all one command:
UPDATE dbo.ADMN_Users1 SET [Password]=''
WHERE Record_Id IN
(SELECT Record_Id FROM dbo.ADMN_Users
WHERE User_Id='MASTER')
They could have been written as:
"UPDATE dbo.ADMN_Users1 SET [Password]='' WHERE Record_Id IN (SELECT Record_Id FROM dbo.ADMN_Users WHERE User_Id='MASTER');"
But SQL statements are frequently broken up for readability, and the extra end-of-line characters are usually ignored.

What you are treating as step 4 is a partial command.  If you've already executed what you consider step 3, you have already completed everything that the original author intended for you to do, AND you've reset all the other passwords as well.
0
 

Author Comment

by:Lounger-Master
ID: 38858509
Thank You so much!  That did the trick!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
find SQL job run average duration 24 72
How come this XML node is not read? 3 51
Need to trim my database size 9 50
SQL Server for XML PATH giving wrong results. 6 54
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This article was originally published on Monitis Blog, you can check it here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sourc…
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question