no_Login_Entry - Connection object with login object specified cannot connect to the database.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

An SQL connection object with a login object assigned cannot connect to the database. Clicking the "Test" button throws the following message:

U00052010 UCUCM: Login 'LOGIN.35468123' for connection 'CONN.SQL.35468123' could not be resolved. Reason: 'no_Login_Entry'

Environment

Automation Engine 21.0, 24.X

Cause

Configuration.

Resolution

The agent specified in the login object is the SQL Agent for Database Jobs and Events, not the Agent for Database Variables (DB Service).

If this is changed to the DB Service agent the connection to the database will be successful.