reset of admin password

system · January 21, 2009, 2:18pm

Hi members

I have for the administrator password can u tell me what all the steps i need to follow to reset the password for cmc.

regards

Singh

yadavendrasingh (BOB member since 2009-01-21)

system · January 21, 2009, 2:42pm

Hi

Are you lost the password and needs to reset or you just needs to know how to reset the password for admin account in CMC…?

Regards
Siva.M

looksmee (BOB member since 2006-02-08)

system · January 21, 2009, 3:58pm

Well i just want to know how to reset the password

yadavendrasingh (BOB member since 2009-01-21)

system · January 21, 2009, 4:10pm

Moved to CMC from Semantic Layer, thanks

Dave Rathbun (BOB member since 2002-06-06)

SebastienGoiffon · January 21, 2009, 4:30pm

Did you lose it thus you can no longer logon the CMC or do you want to reset it?

system · January 22, 2009, 3:59am

I don’t know why we are answering a question with a question. The original poster is simply asking how to reset the password. In CMC, go to users, click on Administrator, there you can change the password, but be careful while you do that.

zack (BOB member since 2007-08-02)

system · January 22, 2009, 3:25pm

In addition to resetting the password in the CMC, it can also be reset in InfoView. Log in as Administrator, go to Preferences, and then to the Password tab/section, and reset the password there.

MichaelWelter (BOB member since 2002-08-08)

system · January 22, 2009, 3:51pm

Maybe I am missing something here, but didn’t the original poster say he needed to reset the admin password? How can you log in to reset it if you can’t log in because you don’t have the admin password?

The way I read the question was: I don’t have the password, so how can I reset it so I can get back in…

Dave Rathbun (BOB member since 2002-06-06)

system · January 22, 2009, 3:55pm

You could be right, Dave. If you don’t know the password, you can’t log in to InfoView to change/reset it. You would have to log into the CMC, as another administrator, and change it.

MichaelWelter (BOB member since 2002-08-08)

system · January 22, 2009, 5:17pm

What if you don’t have another administrator?

Dave Rathbun (BOB member since 2002-06-06)

system · January 22, 2009, 5:32pm

Then you’re in deep yogurt. I don’t know of a way to reset an admin password if you don’t know it, and there’s only one administrator.

MichaelWelter (BOB member since 2002-08-08)

system · January 22, 2009, 7:40pm

In which case you can reset it by deleting the record from the CMS database table which stores the admin password and of course it is very risky.

zack (BOB member since 2007-08-02)

system · January 22, 2009, 7:42pm

Since the CMS database is binary data only, how would you delete the record? You can’t use SQL commands against it.

MichaelWelter (BOB member since 2002-08-08)

system · January 22, 2009, 7:51pm

I myself deleted it once on my computer. The CMS database was on SQL Server. Hope that helps.

Edit: Here is that link

zack (BOB member since 2007-08-02)

system · January 22, 2009, 8:08pm

I remember seeing posts which suggested deleting record from cms_infoobjects5 table in the CMS database where the objectid is 12 or 13 and then logging back in as administrator with blank password. Please search the forum for these posts as I don’t recommend this as it is too risky to mess with the CMS database from the backend.

Farhan Jaffery (BOB member since 2005-08-27)

system · March 16, 2009, 2:59pm

So what is the alternative?
Just caught this topic because we’ve managed to acheive the same here. Only one Admin user, password ‘mislaid’, XI3 btw & CMS on SQLServer.
Doh!

Joan Green (BOB member since 2008-08-06)