MS CRM 数据库恢复后无法添加用户
我们已在新版本上恢复了旧的 ms CRM 数据库。但是，当我尝试添加新版本中已存在的用户时，出现错误。
如果我从我们的活动目录中删除用户，然后尝试将它们添加到 CRM，则效果很好。
CRM 是否可能将用户信息存储在 MSCRM_CONFIG.这可以以受支持的方式删除吗？
查看 MSCRM_CONFIG 表中的 SystemUser，我想我需要从该表中删除用户。但我无法执行删除语句，因为它不受支持。 :)
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. :)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您是使用部署管理器工具还是仅通过执行 SQL 还原来还原此数据库？直接从 SQL 执行此操作会导致问题。您需要在部署管理器中删除组织，然后在 SQL 中删除数据库。然后，您应该附加数据库并从部署管理器重新创建组织，将其指向现有数据库。
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.
仅恢复组织数据库可能会导致问题，因为某些用户信息也存储在配置数据库中。事实上，其中有一些条目将用户映射到组织 (SystemUserOrganizations)，因此当您恢复 Org DB 时，此映射现在已过时。
您需要选择删除/导入路径或手动对配置数据库表进行一些不受支持的清理。
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.