on 10-03-2011 11:33 AM
Hi Expert.
I am working on Upgrading SAP PI 7.0 to PI 7.11
i had MS SQL 2005 version 9.00.1399, since 7.1 needs higher version i upgraded it to 9.00.3042
Now when i try to start the server, i get the folloing error.
SAP-Basis System: Initialization DB-Connect Failed, Return Code 000256
Database: > Login failed for user 'HYDHTC165182D\SAPServicePS3'.
Database: Database error -1 at CON
OS: windows 2003 server (64 bit)
Please Help.
Regards
Osman
Hi Expert.
> I am working on Upgrading SAP PI 7.0 to PI 7.11
> i had MS SQL 2005 version 9.00.1399, since 7.1 needs higher version i upgraded it to 9.00.3042
> Now when i try to start the server, i get the folloing error.
>
>
> SAP-Basis System: Initialization DB-Connect Failed, Return Code 000256
> Database: > Login failed for user 'HYDHTC165182D\SAPServicePS3'.
> Database: Database error -1 at CON
>
> OS: windows 2003 server (64 bit)
>
>
> Please Help.
>
> Regards
> Osman
Hello Osman,
Did apply MS SQL server 'higher SP' or what procedure did you use to upgrade SQL Server ?
>>Now when i try to start the server, i get the folloing error.
What server you are trying to start, is it 'Windows Server' ?
>>SAP-Basis System: Initialization DB-Connect Failed, Return Code 000256
> Database: > Login failed for user 'HYDHTC165182D\SAPServicePS3'.
> Database: Database error -1 at CON
Where do you get this error, during sql server 'Service' restart ?
Also, is the sql installation the 'Named instance' or the 'Default' one ?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Please check if this Note applies to your problem -
Note 806925 - SQL Error 4064: Cannot open user default database
Also verify if MS SQL Server services are all up or not. Please verify manual logon to MS SQL Server Studio at OS level.
Please manually verify SAPServiceSID logon to windows, as well.
Please check if you can find something in dev_w* logs from sap work directory.
Thanks
PFB the logs from dev_w0.log
-
trc file: "dev_w0", trc level: 1, release: "700"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Mon Oct 03 17:03:15 2011
B create_con (con_name=R/3)
B Loading DB library 'F:\usr\sap\PS3\DVEBMGS00\exe\dbmssslib.dll' ...
B Library 'F:\usr\sap\PS3\DVEBMGS00\exe\dbmssslib.dll' loaded
B Version of 'F:\usr\sap\PS3\DVEBMGS00\exe\dbmssslib.dll' is "700.08", patchlevel (0.109)
B New connection 0 created
M sysno 00
M sid PS3
M systemid 562 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 111
M intno 20050900
M make: multithreaded, Unicode, 64 bit, optimized
M pid 4680
M
M kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 4680) [dpxxdisp.c 1301]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M
M Mon Oct 03 17:03:16 2011
M DpShMCreate: sizeof(wp_adm) 19248 (1480)
M DpShMCreate: sizeof(tm_adm) 5584592 (27784)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M DpShMCreate: sizeof(comm_adm) 552080 (1088)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (104)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1864)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000F160050, size: 6275136)
M DpShMCreate: allocated sys_adm at 000000000F160050
M DpShMCreate: allocated wp_adm at 000000000F162150
M DpShMCreate: allocated tm_adm_list at 000000000F166C80
M DpShMCreate: allocated tm_adm at 000000000F166CE0
M DpShMCreate: allocated wp_ca_adm at 000000000F6BA3B0
M DpShMCreate: allocated appc_ca_adm at 000000000F6C0170
M DpShMCreate: allocated comm_adm at 000000000F6C20B0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 000000000F748D40
M DpShMCreate: allocated gw_adm at 000000000F748DC0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 000000000F748DF0
M DpShMCreate: allocated wall_adm at 000000000F748E00
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Mon Oct 03 17:03:17 2011
M ThInit: running on host hydhtc165182d
M calling db_connect ...
C Thread ID:600
C Thank You for using the SLOLEDB-interface
C Using dynamic link library 'F:\usr\sap\PS3\DVEBMGS00\exe\dbmssslib.dll'
C dbmssslib.dll patch info
C patchlevel 0
C patchno 110
C patchcomment MSSQL: Connect error handling (1053754)
C np:(local) connection used on HYDHTC165182D
C CopyLocalParameters: dbuser is 'ps3'
C Using Provider SQLNCLI
C OpenOledbConnection: MARS property was set successfully.
C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'HYDHTC165182D\SAPServicePS3'.
C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'HYDHTC165182D\SAPServicePS3'.
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 'HYDHTC165182D\SAPServicePS3'.
C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'HYDHTC165182D\SAPServicePS3'.
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 'HYDHTC165182D\SAPServicePS3'.
C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'HYDHTC165182D\SAPServicePS3'.
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 np:(local).
C Retrying without protocol specifier: (local)
C Using Provider SQLNCLI
C OpenOledbConnection: MARS property was set successfully.
C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'HYDHTC165182D\SAPServicePS3'.
C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'HYDHTC165182D\SAPServicePS3'.
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
C Mon Oct 03 17:03:18 2011
C Using Provider SQLNCLI
C OpenOledbConnection: MARS property was set successfully.
C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'HYDHTC165182D\SAPServicePS3'.
C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'HYDHTC165182D\SAPServicePS3'.
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 'HYDHTC165182D\SAPServicePS3'.
C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'HYDHTC165182D\SAPServicePS3'.
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 'HYDHTC165182D\SAPServicePS3'. [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 'HYDHTC165182D\SAPServicePS3'. [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 hydhtc165182d_PS3_00 on host hydhtc165182d (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Mon Oct 03 17:03:18 2011
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 4680) [dpnttool.c 327]
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.