MS CRM can't add users after database restore

Question

We have restored an old ms CRM database over a newer version. But when I try and add users which were already existed in newer version I get an error.

If I delete the users from our of active directory and then try to add them to CRM it works fine.

Is it possible that CRM is storing user information in the MSCRM_CONFIG. And can this be removed in a supported way?

Have a look at the SystemUser in the MSCRM_CONFIG table, I think i need to remove the users from this table. but I can't do a delete statement as it's not supported. :)

Answer 1

Did you restore this database using the Deployment Manager tool or simply by doing a SQL Restore? Doing this directly from SQL would cause issues. You'll need to delete the organization in the deployment manager and then delete the database in SQL. Then you should attach the database and recreate the organization from the deployment manager, pointing it to the existing database.

Answer 2

Restoring just the org DB can lead to issues as some user info is stored in the config DB as well. In fact, there are entries in there mapping the user to the org (SystemUserOrganizations), so when you restore the Org DB, this mapping is now out of date.

You would need to either go the Delete/Import route or manually do some unsupported cleansing of the Config DB Tables.