Installing multiple instances of Sage CRM - Tomcat & Webapps

For development reasons you may require multiple instances of Sage CRM but how duth one proceedeth , like thus

1. Install the first instance of Sage CRM using the installer

2.   Install the 2^nd Instance using the installer specifying a new instance name / directory

3. Confirm configuration file applicationHost.config in C:\Windows\System32\inetsrv\config for both instances ( check application paths and entries for both CRM instances)

4. Navigate to HKLM/SOFTWARE/Wow6432Node/eWare/Config//CRMName 

and check each CRM instance /CRMNAME and confirm details for

DatabaseTcpPort – Must be unique

Default Database, InstallDir , and database login details

5.  Check both CRM instances are listed under HKLM/SOFTWARE/Wow6432Node/eWare/Mappings in registry

6. Confirm DatabaseTcpPort being used by CRM instance is available and SQL is listening (using sql query below)

USE MASTER
GO
xp_readerrorlog 0, 1, N'Server is listening on'
GO

7.  Confirm SQL port by using SQL configuration manager

8. Check Tomcat Configuration under tomcat\webapps\crminstancename\web-inf

Db.properties or jdbc.properties

#SQL Server settings

db.driver=net.sf.log4jdbc.DriverSpy

db.url=jdbc:log4jdbc:jtds:sqlserver://MachineName-Testy:52289/Sage;language=english;instance=SQL2016

db.username=sa

db.password=&KAHKHDKJASHKD

db.dialect=com.sage.crm.core.data.sqlserver.HibernateDialect

db.connectionCustomizer=com.sage.crm.core.data.sqlserver.ConnectionCustomizer

db.defaultSqlGenerator=com.sage.crm.core.data.sqlserver.SqlGeneratorImp

db.defaultDDLGenerator=com.sage.crm.core.data.sqlserver.MSSqlDDLGenerator

db.connectiontestquery=select @@version

#Hibernate settings

db.hbm2ddl=validate

9.  Confirm each tomcat instance is running on a unique port and this port is not in use by something else

tomcat\conf\server.xml

Unique field include-----

Server port="11005" shutdown="SHUTDOWN"

<Service name="Catalina"> , (e.g catalina1 and catalina2)

<Connector port="11009" protocol="HTTP/1.1"

               connectionTimeout="20000"

               redirectPort="8443" />

<Connector executor="tomcatThreadPool"

               port="11009" protocol="HTTP/1.1"

               connectionTimeout="20000"

               redirectPort="8443" />

Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"

               maxThreads="150" scheme="https" secure="true"

               clientAuth="false" sslProtocol="TLS" />

   

    <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />

<Engine name="Catalina" defaultHost="localhost" jvmRoute="jvm1">

    -->

    <Engine name="Catalina" defaultHost="localhost">

10. Check entries within IIS sdata application – URL Rewrite

 

11.  Restart IIS and Tomcat for changes to take affect

           Any issues with URL rewrite , the installer can be found CRM\Utils\EN\UrlRewriter