gilta03

Tech Tip: Datamaker Connection Error: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

Discussion created by gilta03 Champion on Jan 4, 2018

When trying to setup a repository connection profile in Datamaker, I am receiving the following error message, despite being able to connect to SQL Server outside the tool: 


Connection failed: 
SQLState: ‘28000’ 
SQL Server Error: 18452 
[Microsft][SQL Native Client][SQL Server]Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection. 

 

I followed these steps in the documentation for connecting to the SQL Server Repository: https://docops.ca.com/ca-test-data-manager/4-4/en/installing/install-ca-test-data-manager/connect-to-the-repository 

 

To view the cause and resolution of this issue, please go here- https://support.ca.com/us/knowledge-base-articles.TEC1464783.html 

Outcomes