SQL server connectivity error

Help Studio
, ,
1

Connect to database - OLE DB: Client unable to establish connection
SQL Server Network Interfaces: Error loading adal.dll from system directory. Verify that Active Directory Authentication Library for SQL Server is properly installed. For details, please refer to https://go.microsoft.com/fwlink/?LinkID=513072 [193].
Getting this error while debugging and the below log captured from window event viewer, please help me understanding the issue here.

Event log-
UiPathDebuggingAgent_f32444d9-6c1c-45e5-8822-d8fa44d9241a 35236192 IDebugger EvaluateExpression 8. # System.Exception: Cannot evaluate ‘bodyGetUserPermissions’ at current context. —> System.Activities.InvalidWorkflowException: The following errors were encountered while processing the workflow tree:
‘VisualBasicValue’: Compiler error(s) encountered processing expression “bodyGetUserPermissions”.
‘bodyGetUserPermissions’ is not declared. It may be inaccessible due to its protection level.

at System.Activities.Validation.ActivityValidationServices.ThrowIfViolationsExist(IList1 validationErrors, ExceptionReason reason) at System.Activities.WorkflowInspectionServices.CacheMetadata(Activity rootActivity, LocationReferenceEnvironment hostEnvironment) at UiPath.Activities.Debugger.VBRValueEvaluator.TryEvaluateExpression(String expressionString, Type locationValueType, LocationReferenceEnvironment locationReferenceEnvironment, CodeActivityContext context, IList1 referencedAssemblies, IList1 includedNamespaces, Object& result) --- End of inner exception stack trace --- at UiPath.Activities.Debugger.VBRValueEvaluator.TryEvaluateExpression(String expressionString, Type locationValueType, LocationReferenceEnvironment locationReferenceEnvironment, CodeActivityContext context, IList1 referencedAssemblies, IList1 includedNamespaces, Object& result) at UiPath.Activities.Debugger.VBExpressionEvaluatorBase.Evaluate(String expressionString, Type locationType, IList1 referencedAssemblies, IList1 includedNamespaces) at UiPath.Activities.Debugger.DebugInfo.EvaluateExpression(String expressionString, IList1 referencedAssemblies, IList1 includedNamespaces, ExpressionLanguage expressionLanguage) at UiPath.Executor.Tracking.DebugTrackingParticipant.EvaluateExpressionInternal(String expression) at UiPath.Executor.Tracking.DebugTrackingParticipant.EvaluateExpression(String expression) at UiPath.Executor.DebuggerPlugin.EvaluateExpression(String expression, CancellationToken cancellationToken) at lambda_method(Closure , Object , Object[] ) at UiPath.CoreIpc.Server.Method.Invoke(Object service, Object[] arguments) at UiPath.CoreIpc.Server.<>c__DisplayClass7_3.<.ctor>g__MethodCall|8() at UiPath.CoreIpc.Server.<>c__DisplayClass7_3.<<-ctor>g__InvokeMethod|6>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at UiPath.CoreIpc.Server.<>c__DisplayClass7_1.<<-ctor>g__HandleRequest|3>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at UiPath.CoreIpc.Server.<>c__DisplayClass7_2.<<-ctor>b__5>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at UiPath.CoreIpc.Helpers.<Timeout>d__91.MoveNext()

2

@moni,

  1. Navigate to Add or Remove Programs in the robot machine
  2. In the little search window type sql, or just go find: “Active Directory Authentication Library for SQL Server”.
  3. Uninstall that
  4. Navigate here and download the latest ADAL library (pick x64):
    https://www.microsoft.com/en-us/download/confirmation.aspx?id=48742
  5. Just for kicks, reboot the machine
  6. Your stuff should now properly load adalsql.dll!
3

@sarathi125
Already tried those steps but no luck.