Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TP Connect failed

Hi Experts,

We have installed sql server 2005 sp3 and for some reason the sidadm user profile had some issue and I was not able to login.

The admin guys deleted the profile because of which I could login to the system. But the env. variable was not visible.

so added the standard variable.

Imp: There was some issue while sap startup and the dev_w0 was giving some error related to db connect and mentioned some note and also set the MSSQL_FORCEOLEDB=1. and then SAP came up.

When the env. variable dbms_set = mss was present in user variable of sidadm, and then tested the stms> system> communication --we got this error

DB Connect Link to database failed

Offline Call connect failed due to DbSL load lib fa..

This is tp version 372.04.71 (release 701, unicode enabled)

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to DCO failed (20100625094219).

INFO: no trace information stored

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0249

standard output from tp and from tools called by tp:

-


After changing the env variab ( system ) DBMS_TYPE to mss and deleting from user variable we got the following err

This is tp version 372.04.71 (release 701, unicode enabled)

ERROR: Connect to DCO failed (20100625100539, probably wrong environmen

TRACE-INFO: 1: [dev trc ,00000] Fri Jun 25 10:05:39 2010

0.021323

TRACE-INFO: 2: [dev trc ,00000] DlLoadLib success: LoadLibrary("d

TRACE-INFO: 3:

0.021333

TRACE-INFO: 4: [dev trc ,00000] using "E:\usr\sap\DCO\DVEBMGS

0.021342

TRACE-INFO: 5: [dev trc ,00000] Thread ID:6508

0.023983

TRACE-INFO: 6: [dev trc ,00000] Thank You for using the SLOLEDB-i

0.023998

TRACE-INFO: 7: [dev trc ,00000] Using dynamic link library 'E:\us

0.024017

TRACE-INFO: 8: [dev trc ,00000] dbmssslib.dll patch info

0.024042

TRACE-INFO: 9: [dev trc ,00000] patchlevel 0

0.024052

TRACE-INFO: 10: [dev trc ,00000] patchno 92

0.024062

TRACE-INFO: 11: [dev trc ,00000] patchcomment Improved overflow

0.024076

TRACE-INFO: 12: [dev trc ,00000] np:(local) connection used on SE

0.024124

TRACE-INFO: 13: [dev trc ,00000] CopyLocalParameters: dbuser is '

0.024137

TRACE-INFO: 14: [dev trc ,00000] Using Provider SQLNCLI

0.034997

TRACE-INFO: 15: [dev trc ,00000] OpenOledbConnection: MARS proper

0.035082

TRACE-INFO: 16: [dev trc ,00000] Provider Release:9.00.4035.00

0.098421

TRACE-INFO: 17: [dev trc ,00000] Using Provider SQLNCLI

0.099260

TRACE-INFO: 18: [dev trc ,00000] OpenOledbConnection: MARS proper

0.099302

TRACE-INFO: 19: [dev trc ,00000] i'm dbo but there exists 1 users

TRACE-INFO: 20:

0.113172

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

standard output from tp and from tools called by tp:

Former Member
Not what you were looking for? View more on this topic or Ask a question