How to change SAP HANA password ?

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.

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 M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • 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 ...

                      • SAP S/4 HANA - PREREQUISITES

                        PREREQUISITES 1. Customer must verify that all 7 OData services are ACTIVATED in their SAP system. API_SYSTEM_MONITORING_SRV API_WORK_PROCESS_SRV API_ALERT_MANAGEMENT_SRV BC_EXT_APPJOB_MANAGEMENT API_BGRFC_QUEUE_MANAGEMENT_SRV API_BUSINESS_USERS ...
                      Related Products