This website is not affiliated with, sponsored by, or approved by SAP AG.

disp+work cant connect to msg_server

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: thx4allthefish, Snowy

disp+work cant connect to msg_server

Postby dontlookdown » Wed Jun 27, 2012 4:54 pm

SAPFANS,
I am running ECC6 on a Windows and SQL environment.
We had a hardware failure, so i have just rebuilt\restored our QAS box.
When i go to start SAP, the dispatcher starts, the msg_server starts and goes green, then the disp+work fails after a few seconds.
The dev_w0 says the following:

Code: Select all
Wed Jun 27 22:06:42 2012
M  ThInit: running on host dunqual

M Wed Jun 27 22:06:43 2012
M  calling db_connect ...
C  Thread ID:3352
C  Thank You for using the SLOLEDB-interface
C  Using dynamic link library 'E:\usr\sap\QAS\SYS\exe\run\dbmssslib.dll'
C  dbmssslib.dll patch info
C    patchlevel   0
C    patchno      72
C    patchcomment MSSQL: Thread check in DbSlDisconnect (969143)
C  np:(local) connection used on DUNQUAL
C  CopyLocalParameters: dbuser is 'dbo'
C  Provider SQLNCLI could not be initialized. See note #734034 for more information.
C  Using provider SQLOLEDB instead.
C  OpenOledbConnection: MARS property was not set.
C  OpenOledbConnection: line 23391. hr: 0x8000ffff Cannot open database requested in login 'QAS'. Login fails.
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 4060, sev 0), Cannot open database requested in login 'QAS'. Login fails.
C  Procname: [OpenOledbConnection - no proc]
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 0, sev 0), Invalid connection string attribute
C  Procname: [OpenOledbConnection - no proc]
C  Provider SQLNCLI could not be initialized. See note #734034 for more information.
C  Using provider SQLOLEDB instead.
C  OpenOledbConnection: line 23391. hr: 0x8000ffff Cannot open database requested in login 'QAS'. Login fails.
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 4060, sev 0), Cannot open database requested in login 'QAS'. Login fails.
C  Procname: [OpenOledbConnection - no proc]
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 0, sev 0), Invalid connection string attribute
C  Procname: [OpenOledbConnection - no proc]
C  Provider SQLNCLI could not be initialized. See note #734034 for more information.
C  Using provider SQLOLEDB instead.
C  OpenOledbConnection: line 23391. hr: 0x8000ffff Cannot open database requested in login 'QAS'. Login fails.
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 4060, sev 0), Cannot open database requested in login 'QAS'. Login fails.
C  Procname: [OpenOledbConnection - no proc]
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 0, sev 0), Invalid connection string attribute
C  Procname: [OpenOledbConnection - no proc]
C  failed to establish conn to np:(local).
C  Retrying without protocol specifier: (local)
C  Provider SQLNCLI could not be initialized. See note #734034 for more information.
C  Using provider SQLOLEDB instead.
C  OpenOledbConnection: line 23391. hr: 0x8000ffff Cannot open database requested in login 'QAS'. Login fails.
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 4060, sev 0), Cannot open database requested in login 'QAS'. Login fails.
C  Procname: [OpenOledbConnection - no proc]
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 0, sev 0), Invalid connection string attribute
C  Procname: [OpenOledbConnection - no proc]
C  Provider SQLNCLI could not be initialized. See note #734034 for more information.
C  Using provider SQLOLEDB instead.
C  OpenOledbConnection: line 23391. hr: 0x8000ffff Cannot open database requested in login 'QAS'. Login fails.
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 4060, sev 0), Cannot open database requested in login 'QAS'. Login fails.
C  Procname: [OpenOledbConnection - no proc]
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 0, sev 0), Invalid connection string attribute
C  Procname: [OpenOledbConnection - no proc]
C  Provider SQLNCLI could not be initialized. See note #734034 for more information.
C  Using provider SQLOLEDB instead.
C  OpenOledbConnection: line 23391. hr: 0x8000ffff Cannot open database requested in login 'QAS'. Login fails.
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 4060, sev 0), Cannot open database requested in login 'QAS'. Login fails.
C  Procname: [OpenOledbConnection - no proc]
C  sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 0, sev 0), Invalid connection string attribute
C  Procname: [OpenOledbConnection - no proc]
C  failed to establish conn. 0
B  ***LOG BY2=> sql error 0      performing CON [dbsh#2 @ 1204] [dbsh    1204 ]
B  ***LOG BY0=> <message text not available> [dbsh#2 @ 1204] [dbsh    1204 ]
B  ***LOG BY2=> sql error 0      performing CON [dblink#3 @ 431] [dblink  0431 ]
B  ***LOG BY0=> <message text not available> [dblink#3 @ 431] [dblink  0431 ]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10169]

I have found various threads with the same or similar logs, but still unsure how to resolve.
Any advise is much appreciated,
Thanks.....

dontlookdown
 
Posts: 1
Joined: Wed Jun 27, 2012 4:44 pm

Re: disp+work cant connect to msg_server

Postby adel » Thu Jun 28, 2012 10:10 am

Hi,
according to the logs it seems related to the db. Did you check if it is properly running?
once i had an issue after a reboot because the SAPSR3 password needed to be changed.
check the user if it is locked or issue with the password.
Adel
adel
 
Posts: 55
Joined: Wed Nov 13, 2002 8:59 am
Location: France,Paris


Return to Basis

Who is online

Users browsing this forum: No registered users and 15 guests




This website is not affiliated with, sponsored by, or approved by SAP AG.