Friday 26 September 2014

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.

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

Saturday 20 September 2014

How to Reset "ddic" Password with SAP*


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


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

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

2) SQL Command to show schema used