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



Comments

Popular posts from this blog

Microsoft Visio 2010 Premium Product Keys

Mercedes Benz Diesel CDI EGR Emulator Circuit Diagrams

Fix: The Diagnostic Service Host service failed to start due to the following error. [ solved, no kidding ]