Tag: T-SQL


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) Begin Set @Id = NEWID() INSERT …