CA Release Automation MS SQL Server action error - "The user is not associated with a trusted SQL Server connection"
Article ID: 111616
CA Release Automation - Release Operations Center (Nolio)CA Release Automation - DataManagement Server (Nolio)
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
All versions of CA Release Automation
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.