Problem:A user is encountering the following errors when logging into Everbridge Control Center (CNL):
The specified user account is locked out.
Please try again or contact your administrator.
The user has attempted to log in to CNL three or more times with the incorrect password. Once three incorrect attempts have been made, the account is locked.
To unlock a locked account in the database, please follow these steps. All queries must be run against the Pacific database using SQL Management Studio.
- Find the user ID from the Ipsc.[User] table using the query:
- Copy the value from the ID column. In the above example, the ID of the user whose account is locked out is'27A23AC5-326B-ED11-ABC6-747827CB57AD'
- Unlock the account by executing the following query. (Change ID and UserID in the two queries to use the ID you copied in step 2.)
Delete From [Pacific].[Ipsc].UserLogonHistory Where UserID = '27A23AC5-326B-ED11-ABC6-747827CB57AD'