Technical Questions Technical questions on Kentico CMS Connector for Microsoft SharePoint.
Kentico CMS Connector for Microsoft SharePoint > Technical Questions > Reseting admin password View modes: 
User avatar
Member
Member
hkafel-yahoo - 4/14/2010 11:06:36 AM
   
Reseting admin password
Can someone provide a SQL query for updating the admin password.

I was unable to do so by editing the CMS_user table and leaving the field blank.

Thanks,
H. Kafel

User avatar
Member
Member
kentico_pavelk - 4/15/2010 1:49:08 AM
   
RE:Reseting admin password
Hello,

You can use a query like this:

UPDATE CMS_User SET UserPassword = '' WHERE UserId = 53


This query resets Administrator's password.


Best regards,
Pavel Knotek

User avatar
Member
Member
hkafel-yahoo - 4/15/2010 3:29:36 PM
   
RE:Reseting admin password
Thank you!

Worked perfectly.

User avatar
Member
Member
sean.mylne-seven24it.co - 11/5/2010 1:34:04 PM
   
RE:Reseting admin password
Hi hkafel-yahoo,

back in april you managed to get reset you admin password for sitemanager. My problem is that i can not locate where the cms_user file so i can reset my administrator password?

any ideas would be great.


many thanks

Sean

User avatar
Member
Member
jbeschen@sparknettech.com - 9/9/2010 9:34:23 AM
   
RE:Reseting admin password
Please help, this doesn't work for me. The database shows the entry to be empty but I cant login as administrator w/ a blank password. Any ideas?

User avatar
Member
Member
jbeschen@sparknettech.com - 9/9/2010 9:54:02 AM
   
RE:Reseting admin password
I've now gained access by using the built in 'silver' account and modifying its table entry so it's a global administrator. Even resetting the password in the system fails to unlock the administrator account. I have no idea why it wont work. We were just about to shift off of our free license and move it to a full version to take it live but now I cant get in as administrator.

Please help.

User avatar
Member
Member
jbeschen@sparknettech.com - 9/9/2010 10:05:28 AM
   
RE:Reseting admin password
Figured it out! The administrator was somehow set to a domain user.