SQL source login failed for user

  • 21Views
  • Last Post 02 April 2020
Troy Theobald posted this 01 April 2020



We had to restore our SQL database and since the restore we cannot connect to the source.   Error 'Login failed for user 'xxx'.    Can you explain what permissions we need in SQL for this connection to work?   The account is DBO of the database we're connecting to but I seem to remember there are other permissions needed in SQL for this to work properly.

Thank you

Dmitriy Muzurov posted this 02 April 2020

Hello Troy,

Thank you for submitting a ticket with us.

We can see that the issue with "login failed" error on the package ID 68978 has been solved.

Let us know if you experience any other issues.