How to change SAP HANA password ?
Error : "SAP DBTech JDBC: [414]: As per your password policy, current user is forced to change DB password." error message is shown.
Cause :
The standard password policy specifies that a new user must change their password upon logging into HANA for the first time.
The standard password policy specifies that a new user must change their password upon logging into HANA for the first time.
Solution:
Change SAP HANA DB password or Update Password policy.
Execute in HANA DB :
hdbsql =>
ALTER USER <user> DISABLE PASSWORD LIFETIME
CONNECT <user> PASSWORD "<Password>"
Passwords containing special characters other than an underscore must be enclosed in double quotes (").
SAP Notes :
New to ADSelfService Plus?
Related Articles
SAP HANA Troubleshooting
Problem 1: No Data in SAP HANA Database monitor (or) "SAP DBTech JDBC: [414]: As per your password policy,current user is forced to change DB password." error message is shown. Solution: Change SAP HANA DB password or Update Password policy. Refer ...SAP Server - No Data for SAP OS Tab
Problem: SAP Server, OS Data is not collected. Troubleshooting Steps: Verify if SAP OS Collector (SAPOSCOL) is running. Connect to SAP Server using SAP Logon. Use TCODE RZ20 Expand 'SAP CCMS Monitor Templates' monitor set, select 'Operating System' ...No Data in SAP Server monitor/ Unable to add SAP monitor
Problem: In Appmanager_home/logs/nms/stdout.txt , the error message "SAPDataCollector : Host information not found for server" is found. Solution: Add entry for IP Address and SAP Instance name in etc/hosts file of Applications Manager server and ...SYSTEMDB not connected - SAP HANA
Error : general error : SYSTEMDB not connected Cause : The DEFAULT entry in the hdbuserstore on the sap application server is incorrectly pointing to the sql port of the SYSTEMDB instead of tenant database. Solution : The sql port for the tenant ...Troubleshooting steps for SAP Server/SAP CCMS Monitor addition
SAP Monitor addition gets failed due to the following reasons. User Name / Password is given wrong Check the username and password in SAP Server Logon User account locked - Too many failed attempts : (Need to unlock the user from SAP Server) In SAP ...