Hola Oscar,

In order to set up Sage CRM 7.1 to point on the right server and database, here are the information that you need:

•             Name of the server,

•             Name of Sage CRM Database,

•             Login of SQL Server 2008,

•             Password of SQL Server 2008,

•             Name of SQL Server 2008 instance (default is server name),

•             Port number used to connect to SQL Server (1433 by default).

1-Backup Sage CRM 7.1 database in SQL Server

2-Restore this Sage CRM database in SQL Server 2008 on the new server.

3-Run this query on this database: Select parm_name, parm_value from Custom_SysParams where parm_name = 'ServerNames'

It will return the name of the previous server

4-Run this query to update server name: Update Custom_SysParams SET parm_value = '**NewServerName**' where parm_name = 'ServerNames'. Check by running query from Step 3 that server name is updated correctly.

5-Do a backup of your Windows Registry where Sage CRM is installed,

6-Stop Sage CRM Apache Tomcat Service and Stop IIS,

7-Change values of Windows Registry key:

• HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\/<CRM Install Name>/DatabasePassword = Password of SQL Server 2008,

• HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\/<CRM Install Name>/DatabaseTcpPort= 1433 or the port set up in SQL Server 2008 connection settings.

• HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\/<CRM Install Name>/DatabaseUserID= Login of SQL Server 2008,

• HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\/<CRM Install Name>/DefaultDatabase= Name of Sage CRM Database,

• HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\/<CRM Install Name>/DefaultDatabaseDriver= MSSQL,

• HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\/<CRM Install Name>/DefaultDatabaseServer= Name of the server.

8-Change values of Web Application configuration file by opening with notepad the file called jdbc.properties located in C:\Program Files (x86)\Sage\CRM\<CRM Install Name>\tomcat\webapps\<CRM Install Name>j\WEB-INF folder.

Copy and comment the 4 lines jdbc.driver, jdbc.url, jdbc.username and jdbc.password by adding a # sign in front of them like:

#jdbc.driver=net.sf.log4jdbc.DriverSpy

#jdbc.url=jdbc:log4jdbc:jtds:sqlserver://Server Name:TCP IP Port/CRM Install Name;instance=

#jdbc.username=sa

#jdbc.password=&EOFAJHOLAEONLMGCDCCJEIDOMKJAHPLM

Paste and modify the 4 lines according to these settings:

jdbc.driver=net.sf.log4jdbc.DriverSpy

jdbc.url=jdbc:log4jdbc:jtds:sqlserver://New Server Name: TCP IP Port/CRM Install Name;instance= SQL Server Instance Name

jdbc.username=Login of SQL Server 2008

jdbc.password=Password of SQL Server 2008

9-Save jdbc.properties file,

10-Restart Sage CRM Apache Tomcat Service and Start IIS,

11-Log in Sage CRM as an Admin and verify connectivity to database and server.

Regards,

 Yannick