VERIFIED SOLUTION i

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

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).

 
Environment Details
Product Features: Sagent Automation and BPA server