Solved

Maximizer SQL Password Reset

Posted on 2013-02-03
6
1,684 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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

828 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