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
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.....

