When trying to setup a repository connection profile in Datamaker, we are receiving the following error message, despite being able to connect to SQL Server outside the tool:
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.
We've followed the steps in the documentation for connecting to the SQL Server Repository: https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/installing/install-test-data-manager/connect-datamaker-to-the-repository.html
This error message could be caused by a few different things, so we would normally ask the following troubleshooting questions to narrow down the root cause:
A common cause we see for this error is that your connection string details or format is incorrect.
If you have <servername>\SQLEXPRESS when your instance is actually SQLEXPRESS2014, the connection string should be changed to <servername>\SQLEXPRESS2014.
We also highly recommend reviewing the following knowledge documents with your DBA to resolve the issue:
If you experience any further issues, please open a support case by going to https://support.broadcom.com.