CA Release Automation MS SQL Server action error - "The user is not associated with a trusted SQL Server connection"

book

Article ID: 111616

calendar_today

Updated On:

Products

CA Release Automation - Release Operations Center (Nolio) CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

CA Release Automation - All MS SQL Server Actions fail with the error "Cannot establish database connection: Failed to get connection for: jdbc:sqlserver://dbserver.123abc.com"
Ex: 'Run SQL File on Micorosft SQL Server' action, 

The logs indicate the following error:
An error occurred during database connection establishment Failed to get connection for: jdbc:sqlserver://dbserver.123abc.com;database=CCF_CSC_Extensions (Login failed for user 'SRV-WEB-CCF-SIT-CSC'. The user is not associated with a trusted SQL Server connection. ClientConnectionId:45b351d2-53c1-4641-a6b2-bd7b95951212) Login failed for user 'WEB-CCF'. The user is not associated with a trusted SQL Server connection. ClientConnectionId:45b351d2-53c1-4641-a6b2-bd7b95951212 error code: 0 

Environment

All versions of CA Release Automation

Resolution

This error occurs if the user account being used within the action is not a valid user in Microsoft SQL Server or a Windows user.

MS SQL Server needs to be configured using Mixed Mode Authentication and the user account being used in the action needs to be present in MS SQL Server.