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.
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:
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 …