Skip to main content

Error: 'Login failed for user' on the Database Query (ODBC) step

This occurs when the task is using the wrong account type to log in to the database in the data query step. Set the impersonation on the task to a user account that has permissions to connect to the database:

  1. Log in to TaskCentre.

  2. Find and open the task.

  3. On the General tab, click Options.

  4. On the Impersonation tab, enter the credentials for the account to be used.

  5. Click OK.

  6. Click OK.

Did this answer your question?