Sql Connection Configuration Issues

Symptoms:

Agility (or background) throws exception to event log that system is unable to connect fastNet database., but user can connect to SQL instance with SQL management studio

Investigation Procedure:

Ensure system configuration:

1. Check system name in web.config and in sxpBacground.exe.config files
2. Ensure registry configuration(for standard and Wow6432Node):

   HKEY_LOCAL_MACHINE\SOFTWARE\SoftSolutions\SXP\SystemName
   HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SoftSolutions\SXP\SystemName