Introduction


The Wellnomics Risk Management software stores all user data associated with assessing risks in a Microsoft SQL database. The  data in the database is accessed by the following application components:

  • Wellnomics Portal (IIS website) 
  • Wellnomics IT Administration (IIS website) 
  • Wellnomics Synchronization Application (IIS website) 
  • Wellnomics Synchronization Service (Windows service) 
  • Wellnomics HR Import Service (Windows service)
These components each access the Wellnomics Risk Management database using one of the following data access client accounts  of the SQL server: 
  • WNP_DAC 
  • WPSYNC_DAC 
  • HRIMPORT_DAC 
To move the Wellnomics Risk Management database from one SQL server to another you must perform a full backup of the  database from the first SQL server, and restore that database on the second server. 

Backing up a Wellnomics database and restoring it on a new SQL server can break the “User Mapping” and “Role Membership”  settings associated with that database’s data access client accounts. We recommend that these data access client accounts be removed from the following locations in SQL Server Management Studio, before being manually recreated: 

SQL Server->Databases->Wellnomics->Security->Users
SQL Server->Security->Logins

Once deleted, re-create each of the data access client accounts through SQL Server->Security->Logins. Please ensure the  following: 

  1. Passwords are correctly entered 
  2. No Password Policies are enabled. 
  3. The Default Database is set to the Wellnomics database. 
  4. The Default Language is set to “English”. 
  5. In the “User Mapping” section, map to the Wellnomics database and select the following Database role memberships for  each data access client account. 

Account Role Membership
WNP_DAC Public, WellnomicsCalculator, WellnomicsEditor.
WPSYNC_DAC Public, WellnomicsCalculator, WorkPaceSynchronization.
HRIMPORT_DAC Public, WellnomicsImporter. 


Each of the five Wellnomics Risk Management application components must be reconfigured to connect to the moved database on the  new SQL server. Each of the application components stores its database connection parameters in a separate configuration file within each application’s directory. Please Note: The default directory for each application component is shown here, however your installation may have been made into different directories. 

Each web application and Windows service may need to be restarted after the database connection parameters are modified.

Wellnomics Portal
Configuration file: .\Wellnomics\web.config
Modify the section <connectionStrings> with the correct server connection details:
<connectionStrings>
	<add name="WellnomicsDatabase" connectionString="
		Persist Security Info=False; 
		User Id=WNP_DAC; 
		Initial Catalog={name of Wellnomics database}; 
		Password={password for WNP_DAC}; 
		Data Source={SQL Server instance name}; 
		" providerName="System.Data.SqlClient" />
</connectionStrings>


Wellnomics IT Administration

Configuration file: .\WellnomicsAdmin\web.config

Modify the section <connectionStrings> with the correct server connection details:

<connectionStrings>
	<add name="WellnomicsDatabase" connectionString="
		Persist Security Info=False;
		User Id=WNP_DAC;
		Initial Catalog={name of Wellnomics database};
		Password={password for WNP_DAC};
		Data Source={SQL Server instance name};
		" providerName="System.Data.SqlClient" />
</connectionStrings>


Wellnomics Synchronization Application

Configuration file: .\Wellnomics_Sync\web.config

Modify the section <connectionStrings> with the correct server connection details:

<connectionStrings>
	<add name="WellnomicsDatabase" connectionString="
		Persist Security Info=False;
		User Id=WPSync_DAC;
		Initial Catalog={name of Wellnomics database};
		Password={password for WPSYNC_DAC};
		Data Source={SQL Server instance name};
		" providerName="System.Data.SqlClient" />
</connectionStrings>

 

Wellnomics Synchronization Service

Configuration file: .\Program Files(x86)\Wellnomics\WellnomicsSyncService\ WellnomicsSynchronizationService.exe.config

Modify the section <connectionStrings> with the correct server connection details:

<connectionStrings>
	<add name="WpSyncDatabase" connectionString="
		Persist Security Info=False;
		User Id=WPSync_DAC;
		Initial Catalog={name of Wellnomics database};
		Password={password for WPSYNC_DAC};
		Data Source={SQL Server instance name};
		" providerName="System.Data.SqlClient" />
</connectionStrings>

 

Wellnomics HR Import Service

Configuration file: .\Program Files(x86)\Wellnomics\WellnomicsHRImportService\ WellnomicsService.exe.config

Modify the section <connectionStrings> with the correct server connection details:

<connectionStrings>
	<clear />
	<add name="WellnomicsDatabase" connectionString="
		Persist Security Info=False;
		User Id=HRImport_DAC;
		Initial Catalog={name of Wellnomics database};
		Password={password for HRIMPORT_DAC};
		Data Source={SQL Server instance name};
		" providerName="System.Data.SqlClient" />
</connectionStrings>