Imanami Community

ERR: Login failed for user ‘[USER NAME]’. Reason: Not associated with a trusted SQL Server connection

This article applies to:

• DTM 2.0
• DTM 2.3
• DTM 3.0

SYMPTOM

The following error message may appear when authenticating against a SQL database using Windows Authentication credentials:

Login failed for user ‘[USER NAME]’. Reason: Not associated with a trusted SQL Server connection.

CAUSE

DTM does not support Windows Authentication when using SQL as your source or destination database.  Here is why:  A Scheduled task will ALWAYS run as the currently logged in user.  In the case of the scheduled task this will usually be a system service account.  This account may not have the same access rights as the user that created the job.  In addition, SQL server may be outside the current domain and windows authentication would not work outside of the current domain without trust relationships being established.  Therefore, ONLY SQL server authentication should be used when synchronizing information to your SQL database.

STATUS

Imanami has confirmed this to be a problem with the above referenced product.