What if I change the username in Sitecore using SQL command?

UPDATE dbo.aspnet_Users WITH (ROWLOCK)
       UserName = @NewUserName
       UserName = @UserName


I tried it and found that I can't see all other user data anymore (see screen shot). But the data does exist in core database.

enter image description here

What could be the issue?

1 Answer 1


You need to change the LoweredUserName column as well. I just tried that and it seems to work.

I couldn't verify if the affected user can still logon or whether he encountered any issues after the update, but the user list was updated correctly and I can still see the full name, email etc...


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.