How to avoid duplicate records for external users in the CMS_User table
Knowledge Base Article
When you use Windows authentication, which creates external users in Kentico CMS, the database can sometimes return an unexpected result when updating users. You might find a duplicated record for the same user or perhaps that a user loses roles or custom changes made through the administration interface. This article describes how to avoid this.