Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have several dataflows connected to SAP Hana and they started to fail some days ago. It shows the following error: password logon no longer possible: too many failed attempts. It doesn't seem to be a problem of my SAP user because I'm able to connect via other platforms. Has anyone experienced the same issue?
Thank you in advance 🙂
Solved! Go to Solution.
Hi @miguel_BI
The error message "password logon no longer possible: too many failed attempts" from SAP HANA suggests that the system has locked the account due to multiple incorrect password attempts. This is a security feature designed to prevent unauthorized access. Even though you're able to connect via other platforms, this issue specifically affects the ability to log in through the dataflows that connect to SAP HANA. Here are a few steps and considerations to troubleshoot and resolve this issue:
1.Check Account Lock Status in SAP HANA:
Using SAP HANA Studio: Connect to the SAP HANA system using an administrative account and check the user account status. If the account is locked, you can unlock it here.
Using SQL: Connect to the database using a DBA or an account with sufficient privileges and run a query to check the lock status of the user. If locked, you can also unlock it using SQL commands.
2.Reset Password (If Required):
After unlocking the account, you might need to reset the password to ensure that the credentials used in your dataflows are up to date and correct.
3.Review and Update Dataflows Credentials:
Ensure that the credentials used in your dataflows are correct. If you had to reset the password, you need to update these credentials in each dataflow configuration that connects to SAP HANA.
4.Check for Automated Processes:
Sometimes, automated processes or scripts might attempt to connect to SAP HANA with outdated credentials, causing multiple failed login attempts. Review any automated jobs or processes that use the SAP HANA credentials to ensure they have the correct password.
5.Review SAP HANA Security Policies:
SAP HANA might have security policies regarding password complexity, expiration, and lockout policies. Ensure your passwords and account management practices are in compliance with these policies to prevent future lockouts.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @miguel_BI
The error message "password logon no longer possible: too many failed attempts" from SAP HANA suggests that the system has locked the account due to multiple incorrect password attempts. This is a security feature designed to prevent unauthorized access. Even though you're able to connect via other platforms, this issue specifically affects the ability to log in through the dataflows that connect to SAP HANA. Here are a few steps and considerations to troubleshoot and resolve this issue:
1.Check Account Lock Status in SAP HANA:
Using SAP HANA Studio: Connect to the SAP HANA system using an administrative account and check the user account status. If the account is locked, you can unlock it here.
Using SQL: Connect to the database using a DBA or an account with sufficient privileges and run a query to check the lock status of the user. If locked, you can also unlock it using SQL commands.
2.Reset Password (If Required):
After unlocking the account, you might need to reset the password to ensure that the credentials used in your dataflows are up to date and correct.
3.Review and Update Dataflows Credentials:
Ensure that the credentials used in your dataflows are correct. If you had to reset the password, you need to update these credentials in each dataflow configuration that connects to SAP HANA.
4.Check for Automated Processes:
Sometimes, automated processes or scripts might attempt to connect to SAP HANA with outdated credentials, causing multiple failed login attempts. Review any automated jobs or processes that use the SAP HANA credentials to ensure they have the correct password.
5.Review SAP HANA Security Policies:
SAP HANA might have security policies regarding password complexity, expiration, and lockout policies. Ensure your passwords and account management practices are in compliance with these policies to prevent future lockouts.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |