Connecting to the database server using its IP address

You can configure an existing install of Sage CRM to connect to the SQL Server using its IP address rather than its name in the connection strings.

Step 1: Change the administration settings

1. Log on to Sage CRM as a system administrator.
2. Go to <My Profile> | Administration | System | Database.
3. Click Change.
4. In the Default database server (SQL Server Only) option, replace the database server name with its IP address.
5. Click Save.

Step 2: Update the database properties files

1. Open the Sage CRM installation folder.
   
   By default, this is %ProgramFiles(x86)%\Sage\CRM\CRM.
2. Locate the following files:
   • tomcat\webapps\crmj\WEB-INF\db.properties
   • tomcat\webapps\crmExchangeSyncEngine\WEB-INF\db.properties
3. Open and edit each db.properties file as follows:
   1. Under the #SQL Server settings element, locate the db.url property.
   2. In the property value, replace the database server name with its IP address.
      
      For example: 
      
      db.url=jdbc:log4jdbc:sqlserver://10.2.88.5:1433;databaseName=CRM;language=English;
      
      where 10.2.88.5 is the database server IP address.
      
      
   3. Save your changes.