SQL DBs integration account password changed but getting error even after updating new password
search cancel

SQL DBs integration account password changed but getting error even after updating new password

book

Article ID: 407947

calendar_today

Updated On:

Products

VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

  • In Aria Automation Orchestrator, the password was updated for a SQL Database using the SQL plugin 
  • The "Update a Database" workflow was sun successfully to update the password
  • Workflows that use the database still fail whit this error: "java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication"

Environment

Aria Automation Orchestrator 8.x

Cause

The password is cached in the running vco service

Resolution

Delete the vco pods to restart the service and release the cached credentials

  1. SSH to the appliance using root
  2. kubectl delete pod -n prelude -l app=vco-app
    Note: This command only needs to be run on one node and will delete and restart the pods on all of the cluster nodes

Powered by Wolken Software