Where to search for Sage CRM Configuration components

By | July 31, 2014

Few days back there was an very interest question asked on Sage CRM community. I took over a client and they already has Sage CRM installed but has never setup it up or used it. How can I find out database name, etc. that was used when installing Sage CRM?

New Stuff: Email Order from Web Order Entry screen

In this post, we will be explaining how new user or implementer can identify the Sage CRM configuration elements without login into Sage CRM.

User can easily identify Sage CRM related elements from registry editor. Follow the steps mentioned below to navigate to Sage CRM configuration nodes in registry:
1) Start | Run | Type ‘regedit’ and navigate to Sage CRM configuration path in registry as shown below.

Reg1
For 32-bit machine,
HKEY_LOCAL_MACHINE\SOFTWARE\eWare\Config\<<CRMInstanceName>>
For 64-bit machine,
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\<<CRMInstanceName>>
2) On the right hand side section, all Sage CRM configurator are listed. Using these elements one can easily determine the Sage CRM License Details, Sage CRM Installation Directory, Logging set in Sage CRM, Database configuration and Sage CRM versions. Let us understand them one by one.
a) DatabaseTcpPort: Determines TCP port of Sage CRM database server.
b) DefaultDatabase: Determines Sage CRM database name.
c) DefaultDatabaseServer: Determines Sage CRM database server name.
d) InstallDirName: Physical path of Sage CRM installation directory.
e) LicenseKey: Determines Sage CRM database password.
f) SQLLogging: System logging levels.
g) Version: Sage CRM version installed on server.
Note – It is always advised to contact your Sage Partner who can guide you for a smooth transition.
Also Read: 
1) Identify Sage CRM Administrator users
2) How to identify and backup correct Sage CRM Database
3) Sage CRM Database Maintenance
4) SageCRM and SQL Collation setup
5) How log files are maintained in Sage CRM