DB Connect - Link to database failed

[Former Member]

I encountered error when I use the TMS Check Transport Tool. Both DB Connect and Offline Call failed during tp Call. Below are the log from the error.

I have seen through notes 351586 TP: DBSL error 107, DB error 208 with Connect and have set up the enviornment variables and the users in the SQL server. Yet am not able to resolve the issue.

Thanks,

Aniruddha

ERP: DB_CONNECT

This is tp version 370.00.09 (release 700, unicode enabled)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBNAME is no longer used.

ERROR: Connect to ERP failed (20070430005138, probably wrong environment).

TRACE-INFO: 1: [dev trc ,00000] Mon Apr 30 00:51:38 2007 2031 0.002031

TRACE-INFO: 2: [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 9 0.002040

TRACE-INFO: 3: [dev trc ,00000] using "D:\usr\sap\ERP\DVEBMGS10\exe\dbmssslib.dll" 9 0.002049

TRACE-INFO: 4: [dev trc ,00000] Thread ID:5552 1578 0.003627

TRACE-INFO: 5: [dev trc ,00000] Thank You for using the SLOLEDB-interface 10 0.003637

TRACE-INFO: 6: [dev trc ,00000] Using dynamic link library 'D:\usr\sap\ERP\DVEBMGS10\exe\dbmssslib.dll'

TRACE-INFO: 7: 18 0.003655

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

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

TRACE-INFO: 10: [dev trc ,00000] patchno 72 7 0.003689

TRACE-INFO: 11: [dev trc ,00000] patchcomment MSSQL: Thread check in DbSlDisconnect (969143)

TRACE-INFO: 12: 11 0.003700

TRACE-INFO: 13: [dev trc ,00000] np:(local) connection used on IWDFVM2160 62 0.003762

TRACE-INFO: 14: [dev trc ,00000] CopyLocalParameters: dbuser is 'dbo' 12 0.003774

TRACE-INFO: 15: [dev trc ,00000] Using Provider SQLNCLI 7171 0.010945

TRACE-INFO: 16: [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 117 0.011062

TRACE-INFO: 17: [dev trc ,00000] Provider Release:9.00.1399.06 55773 0.066835

TRACE-INFO: 18: [dev trc ,00000] Using Provider SQLNCLI 412 0.067247

TRACE-INFO: 19: [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 74 0.067321

TRACE-INFO: 20: [dev trc ,00000] i'm dbo but there exists 1 users <> dbo with tables SVERS ==> connect terminated

TRACE-INFO: 21: 4320 0.071641

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:

[yuezhi_zhao · Accepted solution]

Hello,

Can you please check the instance profile of parameter dbs/mss/schema? And what is the value of environment varible MSSQL_SCHEMA for the user <SID>adm and SAPService<sid>? They're supposed to be the same.

Regards,

Joe

[Former Member · Accepted solution]

Hi,

The environment variables are the same for erpadm and SAPServiceERP, ERP being the <SID>.

When i try to connect from command line using the command tp PF=d:\usr\sap\trans\bin\TP_DOMAIN_ERP.PFL connect ERP. this works fine for user erpadm. but somehow it is falling when i try to run the Check tool through STMS transaction. I have re-started the server, been through the registries but the failed DB_Connect is not going away.

Regards,

Aniruddha Gargya

[yuezhi_zhao · Accepted solution]

Hello,

How about the instance profile? What's set for the parameter dbs/mss/schema in the default or instance file?

Regards,

Joe

[Former Member · Accepted solution]

The default profile (default.pfl) has the following entries.

SAPDBHOST = IWDFVM2160

dbms/type = mss

dbs/mss/server = IWDFVM2160

dbs/mss/dbname = ERP

dbs/mss/schema = erp

system name being IWDFVM2160.

None of the other profile files have any of the entries mentioned above: the files are(ERP_DVEBMGS10_iwdfvm2160, ERP_SCS00_iwdfvm2160)

Do i need to make an entry in any of these files.

Regards,

Aniruddha

[Former Member · Accepted solution]

HI,

This is to update the post with the solution that we found.

SAP NOTE 610640 and 1023661. did the trick for us.

Thank you for all your inputs.

-Aniruddha

[Former Member · Accepted solution]

Hi Aniruddha,

I'm facing exactly the same problem. I tried the everything else and also te notes you have suggested. The sp_check_sap_login procedure is running for more than 10 minutes in the repair mode!! and i cancelled it.

Please let me know what exactly you did to solve this issue.

Thanks in Advance

[Former Member]

Set Environment variable in the user <SID>adm / SAPService<sid> and windows registry HKEY_LOCAL_MACHINE > SOFTWARE > SAP > <SID> > Environment >

DBMS_TYPE = mss