Difference between revisions of "Sql Connection Configuration Issues"
From Agility
(Created page with "Symptoms: User can connect to SQL instance with SQL management studio, but Agility (or background) throws exception (in event log) that fastNet it is unable to connect with sql") |
|||
| Line 1: | Line 1: | ||
| − | Symptoms: | + | '''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: | ||
| + | #Check system name in ''web.config'' and in ''sxpBacground.exe.config'' files | ||
| + | #Ensure registry configuration(for standard and Wow6432Node): | ||
| + | HKEY_LOCAL_MACHINE\SOFTWARE\SoftSolutions\SXP\SystemName | ||
| + | HKEY_LOCAL_MACHINE\SOFTWARE\'''Wow6432Node'''\SoftSolutions\SXP\SystemName | ||
Revision as of 10:35, 14 December 2016
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:
- Check system name in web.config and in sxpBacground.exe.config files
- Ensure registry configuration(for standard and Wow6432Node):
HKEY_LOCAL_MACHINE\SOFTWARE\SoftSolutions\SXP\SystemName HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SoftSolutions\SXP\SystemName
