Skip to Content
avatar image
Former Member

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:

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 25, 2010 at 10:37 AM

    > 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

    The SAP system does not run under user <sid>adm but under user SAPService<SID> - so you need to the set the environment for that user. Any environment setting for <sid>adm is pointless.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Markus Doehr

      Hi Markus,

      Thanks a lot of your constant support whenever required.

      With regards to the issue, the sidadm user had the problem. so does it required that sapservicesid was must have gone wrong.

      SAP has recommended to go through the notes 128126 , 98678 but hardly it is useful.

      If you think of any other alternative, do let me know. I shall try it.

      Regards

      Prash

  • Jun 25, 2010 at 09:45 PM

    Hello,

    Please check schema with this note

    Note 1294762 SCHEMA4SAP.VBS

    regards,

    John Feely

    Add comment
    10|10000 characters needed characters exceeded