MS CRM 2011: Add new Deployment Administrator through SQL

(0) Share

Report

Posted on by purwar purwar

2,836

Here is just short script that has to be executed against MSCRM_Config db to add new deployment administrator:

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.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

AaronRic 10,035 on at

Like (0)

Report

RE: MS CRM 2011: Add new Deployment Administrator through SQL

Thanks for posting this. You are correct, this is unsupported and I would not recommend doing this. It would be recommended to add this through Deployment Manager

Was this reply helpful? Yes No