VERIFIED SOLUTION i

Resolve Task processor error :"Login failed for user '####' " - Confirm

Product Feature: Task Processor
 

Issue

The following error is encountered when the Task Processor is trying to run the Scheduled Tasks.

Task Processor failed to process the task. DA_ERR_EMBEDDED SQLSTATE = 28000~r~n[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '######'


 

Cause

This happens, if Confirm userid, that is used to log into the database by the Task Processor,  does not have a valid password in Task processor cfg file.

Resolution

UPDATED: April 21, 2017
Got to the Database setting screen, Create a new configuration(cfg) file for Task Processor.

Replace the old .cfg path with new created .cfg file path in Task processor registry.

 Path from the registy key "CfgFilePath"  for 64-bit Machine: 

'HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Pitney Bowes\Confirm\Task Processor'