Unable to connect ECC application to HANA/ hdbuserstore error
Being a BASIS consultant or a HANA administrator, we face situations several times where we have to connect DB with an application server. Although it is pretty much a straight forward process, but sometime a situation arises where this “NOT SO DIFFICULT” process throws errors at us.
One such scenario that i faced was due to the fact that the application server installation was Local installation rather than being a Domain installation. The below resolution is for cases where the application server is locally installed and the <SID>adm, SAPService<SID> users are local.
This below text can be considered as once of the probable solution to the isue.
Error 91001: System Call ‘LookupAccountName’ faied, rc=1332: No mapping between account names and security IDs was done
To connect a db to application server , we key in below three commands:
hdbuserstore -u <domain name>\SAPService<SID> SET DEFAULT <DB Server ip>:<index server port> SAPABAP1 <password>
hdbuserstore SET DEFAULT <DB Server ip>:<index server port> SAPABAP1 <password>
hdbuserstore SET SUPER <DB Server ip>:<index server port> SYSTEM <password>
If after the first command the error shown in the screenshot above pops up ( Pasting the error below for your convenience), follow the steps
“Error 91001: System call ‘LookupAccountName’ failed, rc=1332:No mapping between account names and security IDs was done”
STEP 1: Check whether the installation performed is domain or local. To check it you can ask the person who did it otherwise you can go to services.msc and there check whether the user running your SAP services has a domain prefix to it or not. if the user looks something like the one shoen below then it is a local installation(dot is included)
.\SAPService<SID> or HOSTNAME\SAPService<SID>
Once confirmed that it is a local installation , in the first command replace the <domain name> with the computer name of your application server and not the FQDN, just the computer name and then you can proceed
This is valid only for windows. In linux systems you can only run the last two commands and the first command is not needed.
In a nutshell we have explained the process of connecting HANA DB to SAP application both on Windows and Linux machines.
Please share your feedback if you face such issue and this blog helps you out. Also suggestions are welcome. Please follow for more updates.