VERIFIED SOLUTION i

Resolve "Attempt to impersonate client security context failed” error in BPA Automation

Product Features: Sagent Automation and BPA server

 

Issue

On execution of Sagent plan having Baseview as "trusted connection"  option with the database produces "Task stopped with user error: Attempt to impersonate client security context failed”. error in BPA. The same issue also occurs in the older version of Opalis 4 Automation.
 
 

 

Cause

Sagent plan using  "Trusted connection "  with DB failed to execute successfully. It throws an error "Task stopped with user error: Attempt to impersonate client security context failed”.
 

Resolution

UPDATED: August 28, 2017
The user needs to use "SQL Authentication" option while creating baseview with the database(s).