The way how to create a trial environment keeps changing so in order to document all the steps to follow I decided to compose the post. I believe it will be helpful not only for myself but for others as well.
Category: Deployment
Microsoft Dynamics CRM 2011: Error after applying Update Rollup 12/13
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:
MS CRM 2011: Add new Deployment Administrator through SQL
Here is a short script that has to be executed against MSCRM_Config db to add a new deployment administrator:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
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) 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 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 …