Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 5 subscribers
  • Views 4550 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SMC 3.5, New installation, Administrator account locked out

AdamCurrie

Hi,

We've had an instance of SMC 3.5 installed, everything was going really well.

Then... one admin didn't speak to the other after a password change and the account was locked out.

I've raised a helpdesk call but don't seem to be getting anywhere so I thought I'd reach out to the community to see if anyone else has any ideas.

I've found the setup wizard and have run through setting up / changing the username and password for the administrator account. Unfortunately, it doesn't change the lockout status.

I've also found and attempted to connect to the OpenLDAP instance, using LDAP v3, SSL, user + password with "cn=mdm-admin,dc=internaluser,dc=com" and with "cn=administrator......"

Still no luck.

If anyone can help, it would definitely be appreciated.

Adam

:43215


This thread was automatically locked due to age.
Parents
  • 0

    Hi Adam,

    if you have configured the password reset setting and an email address for this user, you can use the password reset procedure. Otherwise the only possibility would be to reset the failed logon count directly via the database.

    To do so, connect to the SQL database using the SQL Managment Studio.

    Create a new Query for the SMC database and enter the following line.


    UPDATE smcdb.dbo.mdm_user_property set Value = '0' WHERE PropertyKey = 'pwd_failed_login_count' AND UserId = '1';

    Please note: perhaps you might change the database name at the beginning. 'SMCDB' is the default name created by the setup, but maybe you have adjusted it. In addition, it only applies to the user with the UserID 1. That is always the first user created by the setup. If a different user is affected, you have to adjust the UserID. You can find out the UserID my displaing the content of the table 'mdm_user'.

    Best regards

    Stefan

    :43437
Reply
  • 0

    Hi Adam,

    if you have configured the password reset setting and an email address for this user, you can use the password reset procedure. Otherwise the only possibility would be to reset the failed logon count directly via the database.

    To do so, connect to the SQL database using the SQL Managment Studio.

    Create a new Query for the SMC database and enter the following line.


    UPDATE smcdb.dbo.mdm_user_property set Value = '0' WHERE PropertyKey = 'pwd_failed_login_count' AND UserId = '1';

    Please note: perhaps you might change the database name at the beginning. 'SMCDB' is the default name created by the setup, but maybe you have adjusted it. In addition, it only applies to the user with the UserID 1. That is always the first user created by the setup. If a different user is affected, you have to adjust the UserID. You can find out the UserID my displaing the content of the table 'mdm_user'.

    Best regards

    Stefan

    :43437
Children
No Data
Unfiltered HTML