2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED

[Former Member]

Dear Expert,

I have error on SAPMMC disp+wotk not started R3trans error as

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED

server details win 2003 std + sql 2005

plese find herewith attached error txt for more details.

Thanks,

Santosh

dev_rfc.txt.zip

dev_disp.txt.zip

[Former Member · Accepted solution]

I HAVE ERROR IN MSSQL2005 DATABASE DATABASE IS IN SUSPECT MODE

[Reagan · Accepted solution]

Check this SAP note

1221541  - Getting corrupt SQL server databases back online

Regards

RB

[former_member183107 · Accepted solution]

Hi,

When the database is in SUSPECT mode, you can change the database status to the EMERGENCY mode. This could permit the system administrator read-only access to the database. Only members of the sysadmin fixed server role can set a database to the EMERGENCY state.

You can run the following SQL query to get the database to the EMERGENCY mode.

Collapse | Copy Code

ALTER DATABASE  dbName  SET  EMERGENCY

After that, you set the database to the single-user mode. Single user mode allows you to recover the damaged database.

Collapse | Copy Code

ALTER DATABASE  dbName   SET SINGLE_USER

Then you can run DBCC CheckDB command. This command checks the allocation, structural, logical integrity and errors of all the objects in the database. When you specify “REPAIR_ALLOW_DATA_LOSS” as an argument of the DBCC CheckDB command, the procedure will check and repair the reported errors. But these repairs can cause some data to be lost.

Collapse | Copy Code

DBCC CheckDB (dbName , REPAIR_ALLOW_DATA_LOSS)

If the above script runs without any problems, you can bring your database back to the multi user mode by running the following SQL command:

Collapse | Copy Code

ALTER DATABASE  dbName  SET MULTI_USER

For more info please go through the below links:-

http://www.codeproject.com/Articles/42736/Recover-SQL-Server-2005-Database-from-SUSPECT-Mode

http://www.sapbasiscorner.com/2013/06/26/recover-sql-suspect-mode/

http://blogs.microsoft.co.il/blogs/dbaces/archive/2008/12/28/how-to-repair-sql-server-2005-suspect-d...

Regards,

Himanshu

[Former Member]

Dear Expert R3trans -d not found any error  but

sap disp+work not stated error as

Login failed for user 'SAPDEV\SAPServiceDEV'. [CLIENT: <local machine>]

i was reset all sapservicesid users password but till error not solved.

Thanks & regards,

Santosh

[Reagan]

Run R3trans -d as sidadm user and check the output file trans.log file

Also check the latest dev_w0 trace file.

There will be more information for the reason why SAP doesn't start.

Regards

RB

[Former Member]

also check the link, which is similar...

http://social.msdn.microsoft.com/Forums/en-US/8319b3d7-f2c2-4752-8b6c-8b918a10be7c/ms-sql-related-er...

[Former Member]

Hi,

Please provide the dev_w0 log.

When this stop working . Was there any change done due to which this issue happened.

Thanks

Rishi Abrol

[Former Member]

Hi rishi,

PFA FOR ERROR DETAILS,

PL.SUGGEST

SANTOSH SARKALE

dev_w0.txt.zip

[Former Member]

Hi,

Try updating the kernel.  We tried all solutions found in different forums, whcih were similar to the one above, but nothing worked.  Only when you updat the kernel, the problem will resolve.

BR,

Prabhakar

[AtulKumarJain]

Hi Santosh,

Please check below note

556232 - Environment settings for R/3/Oracle on Windows

yes its is for oracle and your is mss but still u can check this.

also please check DBSL library in your kernel .

Best Regards,

Atul

[Former Member]

Hi,

Thanks for reply,

I have using win2003 _ MS SQL 2005 database.

Thanks,

Santosh

[Reagan]

Hello

Check the dev_w0 trace file

Regards

RB

[Former Member]

hi,,

yes I checked

PFA for your information

Thanks for your reply

Santosh

dev_w0.txt.zip

[Reagan]

OpenOledbConnection: line 23918. hr: 0x8000ffff Login failed for user 'SAPDEV\SAPServiceDEV'.
C  sloledb.cpp [OpenOledbConnection,line 23918]: Error/Message: (err 18456, sev 0), Login failed for user 'SAPDEV\SAPServiceDEV'.

Is this user account locked ?

Regards

RB

[former_member183107]

Hi,

The error is:

Login failed for user 'SAPDEV\SAPServiceDEV

Have u recently changed the user sapservicesid in your system or done any activity?

Also is this ABAP+java stack?

Regards,

Himanshu

[former_member206552]

just to add to RB reply,

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

Best Regards

Marius