on 07-03-2008 7:05 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
By the way, R3trans doesn't throw any error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.