Page History: SQL Server unlocking method
Compare Page Revisions
Page Revision: Wed, 07 Mar 2012 17:34
This error is occurring due to a bug in build 580 when unlocking user accounts with the CW Admin. If all users are locked out of CAREWare and no one is able to log in, then you will need to reset the user account in the actual database due to a bug in the unlocking procedure using the CW Admin utility. We have fixed this bug in build 581 already. In order to work around this bug and unlock the administrator account of CAREWare you will need access to a SQL manager such as Management Studio and access to the database.
To unlock a user account using a SQL manager:
- Connect to the CAREWare instance in the SQL Manager
- Locate the cw_user table
- Return all rows for the cw_user table
- Locate the user name in the column usr_user_name that you want to unlock
- Locate the usr_num_failed_login column for the user
- Change usr_num_failed_login from 3 to 0
- Copy the usr_pk for the desired user to unlock
- Locate the cw_user_domain_map table
- Return all rows for the cw_user_domain_map table
- Locate the usr_pk in the column usr_dm_usr_fk
- Change the usr_dm_locked column value from True to False for the user your are trying to unlock
It would be best to unlock an administrative user account first and specifically unlocked that account for the Central Administration domain. You could compare the cw_domain dmn_pk value for the Central Administration domain to the usr_dm_dmn_fk column in the cw_user_domain_map table in order to do so. Once the administrator account is unlocked they will be able to log in to CAREWare and use one of the unlocking methods to unlock the remaining users.
Back to
Data TierBack to
Frequently Asked Questions