Skip to main content
Matrix42 Self-Service Help Center

Server Migration FAQ

How to determine which databases are used

<ROOT>\bin\sps.config

The following settings are stored in the <ROOT>\bin\sps.config configuration file:

  1. Main Database
<update4u.SPS.DataLayer
databaseConnectString="Data Source=<DB_SERVER>;Initial Catalog=<MAIN_DATABASE>;Integrated Security=True "
...
/>
  1. File Storage Database
<update4u.SPS.DatabaseFileStorage
connectionString="Data Source=<DB_SERVER>;Initial Catalog=<MAIN_DATABASE>;Integrated Security=True "
...
/>
  1. History Database 
<update4u.SPS.History
databaseConnectString="Data Source=<DB_SERVER>;Initial Catalog=<HISTORY_DATABASE>;Integrated Security=True "
...
/>
  1.  Data Warehouse Database
<update4u.DataWarehouse
databaseConnectString="Data Source=<DB_SERVER>;Initial Catalog=<DW_DATABASE>;Integrated Security=True "
...
/>
  1. Analysis Database
<update4u.DataWarehouse
databaseConnectString="Data Source=<DB_SERVER>;Initial Catalog=<ANALYSIS_DATABASE>;Integrated Security=True "
...
/> 
  1.  Reporting Services
<update4u.SPS.ReportingServices
server="http://<DB_SERVER>/ReportServer"
rootFolder="/<ROOT_FOLDER>"
...
/>

<ROOT>\svc\Config\ConnectionStrings.config

The following settings are stored in the <ROOT>\svc\Config\ConnectionStrings.config configuration file:

Workflow Monitoring and Instance Store Database

<connectionStrings>
<add connectionString="Data Source=<DB_SERVER>;Initial Catalog=<MONITORING_DB>;Integrated Security=True" name="M42MonitoringConnectionString" />
<add connectionString="Data Source=<DB_SERVER>;Initial Catalog=<INSTANCESTORE_DB>;Integrated Security=True" name="M42PersistenceConnectionString" />
</connectionStrings>

How to determine application version

The current version is stored in the <ROOT>\bin\sps.config file where <VERSION> is the application version:

<update4u.SPS.Console
...
productVersion="VERSION"
...
/>

The version number consists of several parts that are explained on the scheme below.

SVS_INST_Migration.png

How to determine service account

The service account is stored in the <ROOT>\bin\sps.config file:

<update4u.SPS.Console
...
serviceAccount="="<DOMAIN>\>USER>"
...
/>

How to determine installation directory

By default, Matrix42 Software Asset & Service Management is installed under C:\Program Files (x86)\Matrix42\Matrix42 Workspace Management.

To determine the installation directory, perform the following steps:

  1. Start Registry Editor. From the command line, run regedit.exe.
  2. Navigate to KEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\Matrix42.
  3. Check the value of the InstallLocation key.