How to test FTP Connection on SAP GUI

One of the ways to test the connection of FTP in SAP GUI with FTP server.

1) Execute TCODE: SA38 and enter the program name: RSFTP002

2) Enter the FTP username, password, IP, FTP command to be execute and the RFC connection. Click the "Execute" button.

3) Example of the connection details.

Others:

1) Default RFC connection for FTP

2) Ports require for the FTP connection (ex: used for firewall policies/rules)

*NN = instance number 

(DEV instance number:38 port use: 3338, QAS instance number:68 port use: 3368 etc).

How to Reset "ddic" Password with SAP*

Scenario:

You have forgotten the ddic password on client:000 during patch activity and do not have any other login to reset the password.

The solution is to use the default "SAP*" user to reset the password

Steps:

1) Login to any other client -> execute TCODE: RZ10 -> change the parameter: "login/no_automatic_user_sapstar =0"  (this is to allow "SAP*" to access the system)

2) Save and activate the profile

3) Restart the SAP services

4) Now login into the client:000 with user: "SAP*" and password: "pass"-> execute TCODE: SU01 -> Reset the "ddic" password

5) Repeat the same step as step 1 and 2 by changing the "login/no_automatic_user_sapstar =1" (to disable "SAP*" access to system)

6) Restart the SAP services

7) System is secure and "SAP*" no longer acessible

Others:
1) SQL command to check whether "SAP*" exist in table: USR02

2) SQL Command to show schema used