question

ZZA-0977 avatar image
0 Votes"
ZZA-0977 asked Monalv-msft edited

Connection ADO NET .

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered

@ZZA-0977,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @ZZA-0977 ,

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.






cm-userpa.png (34.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ZZA-0977 ,

May I know if you have anything to update?

Best Regards,
Mona

0 Votes 0 ·