on 08-19-2011 2:59 AM
HI EXPERTS I TRY TO IMPORT A SUPPORT PACKAGE IN SOLMAN WINDOWS SERVER 2008 R2 WITH SQL SERVER 2008 R2 BUT A I CANu00B4T BECAUSE THE USER <SID>ADM DONT HAVE PERMISION TO LOGON DB. I APLIED R3trans.exe -d WITH THE USER <SID>ADM AND AS A RESULT IS THAT:
4 ETW000 E:\usr\sap\slm\sys\exe\uc\NTAMD64\R3trans.exe version 6.14 (release 701 - 23.07.10 - 09:23:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 18.08.2011 - 14:44:43
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: E:\usr\sap\slm\sys\exe\uc\NTAMD64\R3trans.exe -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Thu Aug 18 14:44:46 2011 11769 0.011769
4 ETW000 [dev trc ,00000] db_con_init called 25 0.011794
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 633 0.012427
4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 52 0.012479
4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000186BB0000
4 ETW000 139786 0.152265
4 ETW000 [dev trc ,00000] using "E:\usr\sap\slm\sys\exe\uc\NTAMD64\dbmssslib.dll" 16 0.152281
4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 18 0.152299
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll 19 0.152318
4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "700.08", patchlevel (0.117) 3239 0.155557
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll 29 0.155586
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll 21 0.155607
4 ETW000 [dev trc ,00000] New connection 0 created 31 0.155638
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 49 0.155687
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 24 0.155711
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 16 0.155727
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 44 0.155771
4 ETW000 [dev trc ,00000] Thread ID:7748 16461 0.172232
4 ETW000 [dev trc ,00000] Thank You for using the SLODBC-interface 24 0.172256
4 ETW000 [dev trc ,00000] Using dynamic link library 'E:\usr\sap\slm\sys\exe\uc\NTAMD64\dbmssslib.dll'
4 ETW000 32 0.172288
4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 27 0.172315
4 ETW000 [dev trc ,00000] SAP patchlevel 0 16 0.172331
4 ETW000 [dev trc ,00000] SAP patchno 117 15 0.172346
4 ETW000 [dev trc ,00000] Last MSSQL DBSL patchlevel 0 19 0.172365
4 ETW000 [dev trc ,00000] Last MSSQL DBSL patchno 117 29 0.172394
4 ETW000 [dev trc ,00000] Last MSSQL DBSL patchcomment Tables ########## in SM50 or SM66 (1523684)
4 ETW000 77 0.172471
4 ETW000 [dev trc ,00000] lpc:(local) connection used on SMAPORTA 3990 0.176461
4 ETW000 [dev trc ,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2285]
4 ETW000 42813 0.219274
4 ETW000 [dev trc ,00000] (18456) [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SMAPORTA\slmadm'.
4 ETW000 31 0.219305
4 ETW000 [dev trc ,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2285]
4 ETW000 2399 0.221704
4 ETW000 [dev trc ,00000] (18456) [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SMAPORTA\slmadm'.
4 ETW000 31 0.221735
4 ETW000 [dev trc ,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2285]
4 ETW000 2398 0.224133
4 ETW000 [dev trc ,00000] (18456) [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SMAPORTA\slmadm'.
4 ETW000 31 0.224164
4 ETW000 [dev trc ,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2285]
4 ETW000 3724 0.227888
4 ETW000 [dev trc ,00000] (18456) [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SMAPORTA\slmadm'.
4 ETW000 32 0.227920
4 ETW000 [dev trc ,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2285]
4 ETW000 2440 0.230360
4 ETW000 [dev trc ,00000] (18456) [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SMAPORTA\slmadm'.
4 ETW000 31 0.230391
4 ETW000 [dev trc ,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2285]
4 ETW000 2433 0.232824
4 ETW000 [dev trc ,00000] (18456) [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SMAPORTA\slmadm'.
4 ETW000 31 0.232855
4 ETW000 [dev trc ,00000] Connection 0 failed using Driver={SQL Server Native Client 10.0};Server=SMAPORTA;AutoTranslate=no;Trusted_Connection=yes;WSID=SMAPORTA;APP=R3 00 comm rd ODBC;Database=SLM;
4 ETW000 41 0.232896
4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 18456 performing CON [dblink#4 @ 433] 8207 0.241103
4 ETW000 [dblink ,00433] ***LOG BY0=>[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SMAPORTA\slmadm'. [dblink#4 @ 433]
4 ETW000 42 0.241145
2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'SMAPORTA' DBNAME = 'SLM'"
PLEASE HELP ME EXPERTS!!!
Hello,
This error may came from incorrect authorization. Check note [1294762|http://service.sap.com/sap/support/notes/1294762] (schema repair script).
Regards,
Eduardo Rezende
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Eduardo Rezende
At this time the addon was aplied but i consider your sugestion because this user have been regenerated, and dont have the correct profile thas was created in the installation,
I solved the error to add the variables and paths into user.
I think thath in the future i would have problems with that user sid-adm. Do you have any suggestion for this ..?????
Im new in SAP System.
Best Regards,
Felipe
Hello Felipe,
I don't know if I understood your question right. I suggested note 1294762 becuase of the following:
***LOG BY2=>sql error 18456 performing CON
***LOG BY0=>[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SMAPORTA\slmadm'.
This kind of message "sql error 18456" and "Login failed for user" normally points to authorization/variable/path for the mentioned user.
If you need any further help, just update the thread.
Regards,
Eduardo
Hi Felipe
Could you tell me how did you solve this error right now i am facing the same error.
dblink ,00000] ***LOG BY2=>sql error 18456 performing CON 394 0.045214
4 ETW000 [ dblink ,00000] ***LOG BY0=>Login failed for user 'S02\xxx'. 28 0.045242
2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'DBNAME =xxxx 'xxx
Kindly help me in this.
Hello,
Do you have the environment and profile variables correctly set on both nodes (note 1886616)?
Regards,
Eduardo
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.