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

Document ID : KB000111616
Last Modified Date : 22/08/2018
Show Technical Document Details
Issue:
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.