We recently copied our production database and one of the AW techs scrubbed it with a script to remove the users from it. We are planning on using this database with our test environment. Big problem is we are not able to log into the console with the local admin that we had in the production environment. Is there a default account that was used when the environment was first setup? If not, is there a way to add one without having an account to log in with ? Thank you!!
You can run UPDATE CoreUser SET Password = 'YGjKUvOOa1PrFtvJwv2Emz0CIfZEAfR7zBmN6GxZj3HkR1rp4oggjEowT8WpnBroYm/dIBKqnz8SAHCm4oPY2g==',PasswordSalt = 'ddK4k/4l0P7r7TYySIpvZrQw+IY=' WHERE UserName Like 'administrator' Password for logging is Geslo123!
Hi, will this script also unlock the Administrator account ? Does it unlock automatically ? I've got an on-prem needing assistance where there is no other way currently to log in but the default Administrator, but that account is locked out too.
SELECT * FROM dbo.CoreUser WHERE UserName LIKE 'Administrator'
update dbo.CoreUser set IsLockedOut = 0 where UserName = 'Administrator' update dbo.CoreUser set LastLoginAttempts = 0 where UserName = 'Administrator'
I also delete the ' LastLoginAttempts' ,because when I only reset the ' IsLockedOut' then I have only one try.
