Local SQL User Locked out
# help-with-umbraco
d
Thanks to Azure going up and down all weekend I have a "Too many attempts" lock out of a local SQL DB - V10 site. It's a cloud site and I am logging in with my Umbraco ID but I getting: > The local user xxx xxx for the external provider Umbraco ID is locked out. I have tried:
Copy code
sql
UPDATE umbracoUser
SET userdisabled = 0
WHERE id = 0; -- Replace '0' with the actual user ID
with no luck. I am not sure if this works the same way with Cloud user? Any thoughts?
m
userNoConsole needs to be 0 if I recall
d
Thanks @Matt Wise this worked perfectly. I had tried it at the weekend with no luck but Azure was returning errors as well. For anyone else who needs it:
Copy code
UPDATE [umbracoUser] SET userNoConsole = 0 WHERE UserLogin = 'user@example.com';
7 Views