Declare @DomainName Varchar(Max) Set @DomainName = 'Put new deployment admin login here'--i.e. 'Contoso\Administrator' Declare @Id uniqueidentifier Select @Id = Id From mscrm_config..SystemUser Where Name = @DomainName if (@Id is null) Begin Set @Id = NEWID() INSERT INTO mscrm_config..SystemUser(Id, Name, DefaultOrganizationId) VALUES(@Id, @DomainName, '00000000-0000-0000-0000-000000000000') End 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 domain name of new deployment administrator in a format DOMAIN\Login like Contoso\Administrator.
This trick is 100% unsupported and can lead to malfunction of whole CRM deployment. I suggest you to take backup of MSCRM_Config DB before you run this script.
No comments:
Post a Comment