SSFS issues on Windows

[former_member217353]

Hi All

I recently set up SSFS connection on our SAP QAS  system,

System is up and working but,

I'm facing the following issues:

1. SSFS KeyFile is missing in

   global\security\rsecssfs\key folder

   As per the note 1639578 points 6 is for Unix users and nothing for windows.

2. SQL> drop table OPS$<sidadm>.sapuser;

     ORA00942 -- Table or View doesnt exist

Kind Regards,

Domnic.

[former_member182657]

Hi Domnic,

Apologies for the delayed response.Kindly re-verify the steps as per SAP Note   1622837 - Secure connection of AS ABAP to Oracle via SSFS & re consider SAP Note  1639578 - SSFS as password store for primary database connect content

6.2 Setting and checking the authorization of the SSFS key storage
----------------------------------------------------------------------
If SAPGLOBALHOST runs on Linux or UNIX, carry out step 5.2 for the file <dir_global>/security/rsecssfs/data/SSFS_<sid>.KEY. You do not have to do anything for Windows.

Application server on Windows

----------------------------------------------------------------------

If your application server runs on Windows, proceed as follows: 

Determine the value <dir_global> for DIR_GLOBAL on the relevant application server (for example, using transaction AL11).

Note that the specification for SAPGLOBALHOST occurs as a local path with disk drive letters, whereas the specification for other application servers is a UNC path (for example, \\$(SAPGLOBALHOST)\sapmnt\<sid>\SYS\global).


If you have installed your SAP system in a domain, log on to the operating system as the <domain>/<sid>adm user. Otherwise, log on with the local user <sid>adm.


Open a command box and execute the following commands:



setx RSEC_SSFS_DATAPATH <dir_global>\security\rsecssfs\data




setx RSEC_SSFS_KEYPATH <dir_global>\security\rsecssfs\key

Hope this will help you.

Regards,

Gaurav

[former_member182546]

Hi Domnic ,

Please check the below link .I hope this will help you.

With Regards,

SS

[former_member182657]

Hi Domnic,

Could you share trans.log file by the execution of R3trans -d ?

Regards,

[former_member217353]

Dear Rana,

Appreciate your reply, attaching TRANS.log here.

Kind Regards,

Domnic.

trans-log.txt.zip