R3load.exe failed to connect with return code2

[former_member209809]

Dear Experts,

I am installing SAP netwaver 7.4 PI server on Windows server 2012 and MS SQL 2012.

This is a domain installation so infra team have created 2 users <SID>ADM and SAPService<SID> user with local admin rights.

I have installed MS SQL with windows authentication only installation and after that i was able to connect Db with SQL management studio.

As soon as i have started PI installation after SWPN created DB schema ,granted permission for users and restarted Db engine ...boom error in ABAP import phase as "R3load.exe failed to testconnect with return code2".

I have updated r3trans,r3load,dbsl lib.etc but no good also i have tried to open MS sql management studio but now it is giving error as

"unable to connect with <SID>ADM user"

Any suggestion or help will be highly appreciated.

Warm Regards,

Sumit 

[former_member209809 · Accepted solution]

Dear Team,

I deleted both the users and asked Infra team for domain admin credentials and started installation.

As SAP inst created both users itself so issue got resolved.

Thanks for your valuable help.

Warm Regards,

Sumit

[Sriram2009]

Hi Sumit

Could you paste / attach the sapinst.log

Regards

Sriram

[AtulKumarJain]

Dear Sumit,

Please check  sap note 1886616 and 1294762

http://scn.sap.com/thread/2020350

Best Regards,

Atul

[former_member209809]

Dear Ashutosh and Atul,

please find logs

R3load.exe.log

E:\usr\sap\PID\SYS\exe\uc\NTAMD64\R3load.exe -testconnect

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.036) R3ldctl: fix CDS views creation in upgrade export mode (note 2017805)

DBSL patchinfo (patches.h): (0.033) Memory leak in DBSL reconnect (note 2010675)

--------------------- End of patch information -------------------------

process id 9136

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 99

Trans.log

4 ETW000 R3trans was called as follows: E:\usr\sap\PID\SYS\exe\uc\NTAMD64\R3trans.exe -x

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Thu Jun 05 14:14:49 2014                                               99602  0.099602

4 ETW000  [     dev trc,00000]  db_con_init called                                                       135  0.099737

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000                                                                                                 245  0.099982

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  47  0.100029

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 22  0.100051

4 ETW000  [     dev trc,00000]  Loading DB library 'dbmssslib.dll' ...                                    70  0.100121

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, count 1, addr 00007FFFF69A0000

4 ETW000                                                                                               14312  0.114433

4 ETW000  [     dev trc,00000]      using "E:\usr\sap\PID\SYS\exe\uc\NTAMD64\dbmssslib.dll"               29  0.114462

4 ETW000  [     dev trc,00000]  Library 'dbmssslib.dll' loaded                                            32  0.114494

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbmssslib.dll                    29  0.114523

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "741.10", patchlevel (0.33)                916  0.115439

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbmssslib.dll                 8596  0.124035

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbmssslib.dll                  56  0.124091

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  62  0.124153

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                8067  0.132220

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             54  0.132274

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  38  0.132312

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          22  0.132334

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  47  0.132381

4 ETW000  [     dev trc,00000]  Thread ID:11864                                                         5905  0.138286

4 ETW000  [     dev trc,00000]  Thank You for using the SLODBC-interface                                  59  0.138345

4 ETW000  [     dev trc,00000]  Using dynamic link library 'E:\usr\sap\PID\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000                                                                                                  51  0.138396

4 ETW000  [     dev trc,00000]  7410 dbmssslib.dll patch info                                             40  0.138436

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                      107  0.138543

4 ETW000  [     dev trc,00000]    SAP patchno  33                                                         36  0.138579

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                            26  0.138605

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchno         33                                      26  0.138631

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchcomment Memory leak in DBSL reconnect (2010675)

4 ETW000                                                                                                  38  0.138669

4 ETW000  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 11.0 native                2199  0.140868

4 ETW000  [     dev trc,00000]  lpc:(local) connection used on EQSPIDEV                                  370  0.141238

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2551]

4 ETW000                                                                                              103595  0.244833

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'EQUDOM\pidadm'.

4 ETW000                                                                                                  51  0.244884

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2551]

4 ETW000                                                                                                6321  0.251205

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'EQUDOM\pidadm'.

4 ETW000                                                                                                  49  0.251254

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2551]

4 ETW000                                                                                                5918  0.257172

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'EQUDOM\pidadm'.

4 ETW000                                                                                                  50  0.257222

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2551]

4 ETW000                                                                                               28076  0.285298

Database services are running.

Warm Regards,

Sumit

[Sriram2009]

Hi Sumit

Have you check this SAP Note 2010675 - Memory leak in DBSL reconnect ?

BR

SS

[former_member209809]

Dear Sriram,

I have went through that note and updated kernal files.

But i think this issue is not related to kernal.

Warm Regards,

Sumit

[Sriram2009]

Hi

Have updateted the latest DBSL patch? not kernel

BR

SS

[former_member209809]

Yes sriram i have updated latest DBSL patch with R3load and R3tran.

Warm Regards,

Sumit

[AtulKumarJain]

Hi ,

Pleasase check that are you able to logon using sidadm user and its supplied password is correct.

BR

Atul

[Reagan]

4 ETW000  [     dev trc,00000]  (18456) [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'EQUDOM\pidadm'.

Based on these error codes there are some SAP notes with recommendations. I suggest you to check them and see if they help.

1386328 - Logon to Management Studio Error 18456

542000 - Messages "Error:18456".."Login failed for user 'xx'" appear

1328195 - Error: (Exception: DB), [Microsoft][ODBC SQL Server Driver][Sql Server]Login failed for us...

Note: I only provided only few SAP notes. There are few notes, you may search with the error codes.

Regards

RB

[AtulKumarJain]

Dear Sumit,

Please provide trans.log , what error it is showing .

Is your DB is up and running?

BR

Atul

[former_member185239]

Hi Sumit,

Check the whether the database is up or not. Restart the MSSQL Services.

Paste the output of

1. R3trans -d

2. R3load -testconnect

With Regards

Ashutosh Chaturvedi