Unlock HLR user

1. login into SQL server

select database "ReportServer"

then create new SQL script

Paste SQL command as below

list username who password password locked
select
    UserName,
    IsAnonymous,
    LastActivityDate,
    IsApproved,
    IsLockedOut,
    FailedPasswordAttemptCount
from dbo.aspnet_Users u
    inner join dbo.aspnet_Membership m on u.UserId = m.UserId
where IsLockedOut = '1'


for unlock server
update dbo.aspnet_Membership set FailedPasswordAttemptCount = 0,IsLockedOut=0
where UserId in (select UserId from dbo.aspnet_Users where UserName = 'USER_NAME')