cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR:(18456) [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server

Former Member
0 Kudos

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!!!

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184473
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member184473
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

Yes you are right the thread was that:

***LOG BY2=>sql error 18456 performing CON

***LOG BY0=>Microsofthttp://SQL Server Native Client 10.0SQL ServerLogin failed for user 'SMAPORTA\slmadm'.

And was solved thanks for your help.

Former Member
0 Kudos

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.

former_member184473
Active Contributor
0 Kudos

Hello,

Do you have the environment and profile variables correctly set on both nodes (note 1886616)?

Regards,

Eduardo