cancel
Showing results for 
Search instead for 
Did you mean: 

Installing Central Instance (MSCS) - Sap doesn't start

Former Member
0 Kudos

Hi,

I'm installing a SAP ECC 6 on Cluster (Windows 2003 - MSSQL 2005).

I'm installing the Central Instance in node A but in the step Starting SAP Instance an getting error.

This are the logs.

From MMC Console:

SAP-Basis System: Initialization DB-Connect Failed, Return Code 000256

From dev_w0:

M Thu Jul 03 11:42:21 2008

M ThInit: running on host sproduccion1

M calling db_connect ...

C Thread ID:1912

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'F:\usr\sap\PRD\DVEBMGS02\exe\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 110

C patchcomment MSSQL: Connect error handling (1053754)

C Network connection used from SPRODUCCION1 to SPRODUCCION using tcp:SPRODUCCION

C CopyLocalParameters: dbuser is 'prd'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'SPECTRUM\SAPServicePRD'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'SPECTRUM\SAPServicePRD'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'SPECTRUM\SAPServicePRD'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'SPECTRUM\SAPServicePRD'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'SPECTRUM\SAPServicePRD'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'SPECTRUM\SAPServicePRD'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn to tcp:SPRODUCCION.

C Retrying without protocol specifier: SPRODUCCION

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'SPECTRUM\SAPServicePRD'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'SPECTRUM\SAPServicePRD'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'SPECTRUM\SAPServicePRD'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'SPECTRUM\SAPServicePRD'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'SPECTRUM\SAPServicePRD'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'SPECTRUM\SAPServicePRD'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: 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 -1 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> Login failed for user 'SPECTRUM\SAPServicePRD'. [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error -1 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> Login failed for user 'SPECTRUM\SAPServicePRD'. [dblink#3 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1426]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10283]

M

M Info for wp 0

M

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M req.vm = no VM

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server sproduccion1_PRD_02 on host sproduccion1 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Jul 03 11:42:21 2008

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10486

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 720]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3308) [dpnttool.c 327]

Thanks in advanced,

Wadih Saad

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Check your database administration for users. Looks like the user running SAP can't connect to the database:

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'SPECTRUM\SAPServicePRD'.

C sloledb.cpp OpenOledbConnection,line 23577: Error/Message: (err 18456, sev 0), Login failed for user 'SPECTRUM\SAPServicePRD'.

Try logging into a system under user SPECTRUM\SAPServicePRD, on all nodes of the MSCS, and see if it can access the DB.

Former Member
0 Kudos

Hi

Indeed the user cannot connect to the databse

What can I do to resolve this?

Thanks!

Former Member
0 Kudos

Talk to your DBA, show him what I wrote above, and he should be able to figure it out.

Former Member
0 Kudos

By the way, R3trans doesn't throw any error.