Connection ADO NET .

ZZA 1 Reputation point
2021-02-20T23:54:47.28+00:00

Hi, I am troubleshooting SSIS packages as i keep on receiving "Password logon no longer possible - too many failed attempts. - This error was from ADO NET source data source connection" -error I have checked all the packages are using XML configuration file which has been set earlier. And the password is correct. I suspect there is other password setting that has been configured in any other area that has not been change accordingly. Is there any other area i should check for password ADO NET Source package setting?Please advise.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 24,936 Reputation points
    2021-02-21T02:05:40.39+00:00

    @ZZA ,

    First, you need to turn on logging.
    When it is done, you will be able to link the error to a particular SSIS package name that is using a failing connection.

    After that just investigate that package and its connections.

    0 comments
  2. Monalv-MSFT 5,891 Reputation points
    2021-02-22T03:33:10.177+00:00

    Hi @ZZA ,

    Please check if you use the correct user and password in ADONet Connection Manager.

    70454-cm-userpa.png

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.