disp+work error when I start the SAP system

[Former Member]

Hello,

OS: Windows Server 2008

DB: MS SQL Server 2008

SAP system: SAP ERP 6.0 EHP6

I´m with an error when I try to start the SAP system SDV.

The disp+work is stopped with gray color!

When I try to open the SQL Management Studio with sdvadm (<sid>adm) it show me the following error:

I ran the command R3trans -x in command prompt:

C:\>r3trans -x

This is r3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

unicode enabled version

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'PICDV0401' DBNAME = 'SDV'"

r3trans finished (0012).

This is the output of the trans.log file:

4 ETW000 r3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 26.11.2014 - 01:50:01

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -x

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

4 ETW000  [     dev trc,00000]  Wed Nov 26 01:50:02 2014                                               25196  0.025196

4 ETW000  [     dev trc,00000]  db_con_init called                                                        28  0.025224

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        45  0.025269

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

4 ETW000                                                                                                  31  0.025300

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dbmssslib.dll' ...                                    37  0.025354

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007FEEEB50000

4 ETW000                                                                                                4662  0.030016

4 ETW000  [     dev trc,00000]      using "K:\usr\sap\SDV\DVEBMGS00\exe\dbmssslib.dll"                    16  0.030032

4 ETW000  [     dev trc,00000]  Library 'dbmssslib.dll' loaded                                            17  0.030049

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

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "720.00", patchlevel (0.512)               181  0.030247

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

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

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  39  0.030328

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

4 ETW000                                                                                                 132  0.030460

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

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

4 ETW000                                                                                                  24  0.030514

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          14  0.030528

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

4 ETW000                                                                                                  29  0.030557

4 ETW000  [     dev trc,00000]  Thread ID:6376                                                           906  0.031463

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

4 ETW000  [     dev trc,00000]  Using dynamic link library 'K:\usr\sap\SDV\DVEBMGS00\exe\dbmssslib.dll'

4 ETW000                                                                                                  47  0.031537

4 ETW000  [     dev trc,00000]  dbmssslib.dll patch info                                                  46  0.031583

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       16  0.031599

4 ETW000  [     dev trc,00000]    SAP patchno  512                                                       103  0.031702

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                            23  0.031725

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchno         512                                     15  0.031740

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchcomment Workarea Insert/Update with locators: wrong data written (1901735)

4 ETW000                                                                                                  26  0.031766

4 ETW000  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native                 902  0.032668

4 ETW000  [     dev trc,00000]  lpc:(local) connection used on PICDV0401                                 124  0.032792

4 ETW000  [     dev trc,00000]  Wed Nov 26 01:50:13 2014                                             11624361  11.657153

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

4 ETW000                                                                                                  66  11.657219

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

4 ETW000                                                                                                  28  11.657247

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

4 ETW000                                                                                                4599  11.661846

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

4 ETW000                                                                                                  89  11.661935

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

4 ETW000                                                                                                4627  11.666562

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

4 ETW000                                                                                                  27  11.666589

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

4 ETW000                                                                                                4738  11.671327

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

4 ETW000                                                                                                  28  11.671355

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

4 ETW000                                                                                                4424  11.675779

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

4 ETW000                                                                                                  28  11.675807

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

4 ETW000                                                                                                4411  11.680218

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

4 ETW000                                                                                                  41  11.680259

4 ETW000  [     dev trc,00000]  Connection 0 failed using Driver={SQL Server Native Client 10.0};Server=PICDV0401;AutoTranslate=no;Trusted_Connection=yes;WSID=PICDV0401;APP=R3 00 comm rd ODBC;Database=SDV;

4 ETW000                                                                                                  72  11.680331

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 18456  performing CON                             9476  11.689807

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>Login failed for user 'PICDV0401\sdvadm'.                     29  11.689836

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'PICDV0401' DBNAME = 'SDV'"

Can you tell me what is the problem here? How can I correct this error?

Can you help me please?

Thank you,

samid raif

[Former Member]

Hi Samid,

This error may came from incorrect authorization. Check note [1294762|http://service.sap.com/sap/support/notes/1294762] (schema repair script).

or-----

Login failed for [SQLSTATE 28000] (Error 18456) the step failed

When you query the data from another SQL server (Linked server) and SQL server & agent service is run as a domain user. You may get the error following error message in your job history.

Error:

Executed as user: Domain\XXX.Service. Login failed for user ‘ SSBF\SQL.Service ‘. [SQLSTATE 28000] (Error 18456).  The step failed.

Solution:

Step 1: Check the source SQL server agent logon service account name

All programs –> SQL server 2008 –> Configuration Tools –> SQL server configuration manager. Go to the SQL server agent  –> properties –> Check the logon tab and find the account name.

Step 2: Check the same is available in the target SQL server.

Under the security tab –>logins.  If it’s not available add the domain user with necessary permission on your target machine.

I hope this will help someone.

Regards.

Pravin

[Former Member]

Hi Samid,

Could you refer this scn link

Regards,

Dhuvaraganathan M.

[Former Member]

(18456) [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'PICDV0401\sdvadm

Have a look at the similar thread, where it suggests to use schema repair script.(1294762)

regards,

pavan

[Sriram2009]

Hi Samid

1. Just do the full restart and than try again

2. Your MS SQl DB services started?

3. Could you refer this SAP note & KBA 1876651

1914385 - SQL Server Alias use results in a connection, but w/errors

BR

SS