Rename a Microsoft CRM 2011 Server and it's MSSQL Server
Step1: Edit the MS CRM Config Registry
Step A: Change this registry key
HKLM\SOFTWARE\MICROSOFT\MSCRM\configdb
change:
Data Source=VCRM1;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI
to:
Data Source=VCRM2;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI
Step B: Change this other registry key
HKLM\SOFTWARE\MICROSOFT\MSCRM\ServerUrl
change:
http://VCRM1/MSCRMServices
to:
http://VCRM2/MSCRMServices
Step 2: Edit the MSCONFIG database ( example VCRM1 to VCRM4 )
use MSCRM_CONFIG;
update dbo.Server set name='VCRM4' where NAME='VCRM1';
update dbo.ConfigSettings set HelpServerUrl='http://VCRM4/' where HelpServerUrl='http://VCRM1/';
update dbo.DeploymentProperties set NVarCharColumn='http://VCRM4.homeslice.net:80' where NVarCharColumn LIKE '%VCRM1:80';
update dbo.Organization set ConnectionString='Data Source=VCRM4;Initial Catalog=HomesliceInsurance_MSCRM;Connection Timeout=60;Integrated Security=SSPI';
update dbo.Organization set SrsUrl='http://VCRM4/reportserver' where SrsUrl='http://VCRM1/reportserver';
update dbo.Organization set SqlServerName='VCRM4';
go
Step A: Change this registry key
HKLM\SOFTWARE\MICROSOFT\MSCRM\configdb
change:
Data Source=VCRM1;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI
to:
Data Source=VCRM2;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI
Step B: Change this other registry key
HKLM\SOFTWARE\MICROSOFT\MSCRM\ServerUrl
change:
http://VCRM1/MSCRMServices
to:
http://VCRM2/MSCRMServices
Step 2: Edit the MSCONFIG database ( example VCRM1 to VCRM4 )
use MSCRM_CONFIG;
update dbo.Server set name='VCRM4' where NAME='VCRM1';
update dbo.ConfigSettings set HelpServerUrl='http://VCRM4/' where HelpServerUrl='http://VCRM1/';
update dbo.DeploymentProperties set NVarCharColumn='http://VCRM4.homeslice.net:80' where NVarCharColumn LIKE '%VCRM1:80';
update dbo.Organization set ConnectionString='Data Source=VCRM4;Initial Catalog=HomesliceInsurance_MSCRM;Connection Timeout=60;Integrated Security=SSPI';
update dbo.Organization set SrsUrl='http://VCRM4/reportserver' where SrsUrl='http://VCRM1/reportserver';
update dbo.Organization set SqlServerName='VCRM4';
go
Comments
Post a Comment