I haven’t updated my VM to latest updates for a long time and I decided to do that today. After Rollup was installed, I saw message that said Rollup was not applied to one or several organizations. I ignored that message and tried to log into CRM. I got following error:No Comments
Here is a short script that has to be executed against MSCRM_Config db to add a new deployment administrator:
Declare @DomainName Varchar(Max)
Set @DomainName = 'Put new deployment admin login here'--i.e. 'ContosoAdministrator'
Declare @Id uniqueidentifier
Select @Id = Id From mscrm_config..SystemUser Where Name = @DomainName
if (@Id is null)
Set @Id = NEWID()
INSERT INTO mscrm_config..SystemUser(Id, Name, DefaultOrganizationId)
VALUES(@Id, @DomainName, '00000000-0000-0000-0000-000000000000')
INSERT INTO mscrm_config..SystemUserRoles(Id, SecurityRoleId, SystemUserId)
VALUES(NEWID(), (Select Id From mscrm_config..SecurityRole Where Name = 'Administrator'), @Id)
So the only thing you need to do is to put a domain name of the new deployment administrator in a format DOMAIN\Login like Contoso\Administrator.
This trick is 100% unsupported and can lead to a malfunction of the whole CRM deployment. I suggest you backup MSCRM_Config DB before you run this script.One Comment