Test Data Manager

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

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

    Posted 01-04-2018 04:52 PM

    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