Error starting IDES 6.0 system

[Former Member]

Hello,

When I try to start my IDES 6.0 my work process dies since they are not able to connect to the SQL 2005 DB.

I get messages in the event viewer as - "Login failed for user SAPServiceIDS. Client : <local machine>"

Can someone please guide me how do I make this login sucessfull so that the IDES system starts properly.

Regards,

SAT

[Former Member · Accepted solution]

Hi,

check the password for SAPServiceIDS user in windows if necessary change it,

and assign the new password of this user in windows services.

start -> run -> services.msc -> navigate to SAPIDS_<inst>

right click on that -> properties -> logon assign the new password here which you changed.

regards,

kaushal

[Former Member · Accepted solution]

Hello Kausahl,

THanks for your reply.

I have tried this too.

I resetted the password for SAPServiceIDS user and updated the settings in services.msc

But I am still getting the same error ---

Login failed for user 'IDES61\SAPServiceIDS'. [CLIENT: <local machine>]

Any other alternative?

Can you let me know how do I login into SQL DB from command line?

This is dev_w0 log file

-

---

trc file: "dev_w0", trc level: 1, release: "700"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Sat Mar 12 20:05:27 2011

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\IDS\DVEBMGS00\exe\dbmssslib.dll' ...

B Library 'D:\usr\sap\IDS\DVEBMGS00\exe\dbmssslib.dll' loaded

B Version of 'D:\usr\sap\IDS\DVEBMGS00\exe\dbmssslib.dll' is "700.08", patchlevel (0.72)

B New connection 0 created

M sysno 00

M sid IDS

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 75

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 1648

M

M kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)

M length of sys_adm_ext is 572 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 1648) [dpxxdisp.c 1299]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 18304 (1408)

M DpShMCreate: sizeof(tm_adm) 3994272 (19872)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M DpShMCreate: sizeof(comm_adm) 528064 (1048)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1440)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 07F50040, size: 4653368)

M DpShMCreate: allocated sys_adm at 07F50040

M DpShMCreate: allocated wp_adm at 07F51E40

M DpShMCreate: allocated tm_adm_list at 07F565C0

M DpShMCreate: allocated tm_adm at 07F565F0

M DpShMCreate: allocated wp_ca_adm at 08325890

M DpShMCreate: allocated appc_ca_adm at 0832B650

M DpShMCreate: allocated comm_adm at 0832D590

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 083AE450

M DpShMCreate: allocated gw_adm at 083AE490

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 083AE4C0

M DpShMCreate: allocated wall_adm at 083AE4C8

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M ThInit: running on host ides61

M calling db_connect ...

C Thread ID:3196

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'D:\usr\sap\IDS\DVEBMGS00\exe\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 IDES61

C CopyLocalParameters: dbuser is 'ids'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Sat Mar 12 20:05:28 2011

C OpenOledbConnection: line 23391. hr: 0x8000ffff Communication link failure

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Communication link failure

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Named Pipes Provider: No process is on the other end of the pipe.

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 Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23391. hr: 0x8000ffff Communication link failure

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Communication link failure

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Named Pipes Provider: No process is on the other end of the pipe.

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 Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23391. hr: 0x8000ffff Communication link failure

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Communication link failure

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Named Pipes Provider: No process is on the other end of the pipe.

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 Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23391. hr: 0x8000ffff Communication link failure

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Communication link failure

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Shared Memory Provider: No process is on the other end of the pipe.

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 Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23391. hr: 0x8000ffff Communication link failure

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Communication link failure

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Shared Memory Provider: No process is on the other end of the pipe.

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 Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23391. hr: 0x8000ffff Communication link failure

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Communication link failure

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 233, sev 0), Shared Memory Provider: No process is on the other end of the pipe.

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 10156]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 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 vm = V-1

M

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

M *

M * LOCATION SAP-Server ides61_IDS_00 on host ides61 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Sat Mar 12 20:05:28 2011

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10354

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 1648) [dpnttool.c 327]

Regards,

Satyajit Raskar

[Former Member · Accepted solution]

Hi,

Just check whether all the services like, MSDTC and SQL Server Agent have started. If everything is fine just try to restart windows once.

Sometimes this helps. You can work on SQL Server command line by using the SQL Analyzer window.

Regards,

Suhas

Edited by: Suhas Ajgaonkar on Mar 13, 2008 1:59 PM

[Former Member · Accepted solution]

Hello Suhas,

Thanks for your reply.

I have checked the same....restarting and all but in vain.

Regards,

SAT

[antonio_voce · Accepted solution]

Hi,

try to logon the services with system account - restart the system - start sap.

Antonio.

[Former Member · Accepted solution]

Hi,

Just check whether the user with which you are trying to start the service exists in SQL Server 2005. I am not talking about the OS Level user. I am talking about the SQL Users.

If the user doesnt exist then we need to create the users in SQL.

Please refer SAPNote 551915 - R/3 won't start after database restore or database copy

Regards,

Suhas

[Former Member · Accepted solution]

HI Suhas,

The user exists in SQL 2005 under security.

I ran the service as local account. The SAP system started but with same huge number of errors in application event log.

In event log, the source of the error is SAPIDS_00 & error is -->

Background processing: Batch scheduler: Unable to perform job RFF110S/FSCM BKR1000.

I will go throught that note too.

Regards,

SAT

Basis Consultant

[antonio_voce · Accepted solution]

sorry Satyajit Raskar

but following my instruction now the system run ? You change the user logon of operating system and now sap start .... ?

Antonio.

[Former Member · Accepted solution]

Hi

Could u plz tell me hoe to knw the password of sapsid_00 service

i m unable to start this service on my sap system.

[former_member193399 · Accepted solution]

If you are using the default user id i.e. SAPService<SID> then it is the master password you had given during the installation. Otherwise check the user id by selecting the service from services and see what is the "Log on" is. then go to the computer management under Administrative tools and reset the password. You cannot find out the the existing password if you forgot. Resetting is the only way. Otherwise you have ask around your admin team if anybody else changed the password.

-RT

[former_member193399]

Satyajit,

I am the same error when installing CRM. How did you fix this problem?

-RT

[Former Member]

Hi,

Start the service SAP<SID>_00 using windows local account instead of SAPService user.

I tried restting the pwd of this SAPService user but donno why it was still not giving access to the SQL DB.

So after starting the service using local account, things worked fine. The work processes after startup were able to connct to the DB.

Regards,

SAT

[former_member193399]

satyajit,

I did the same. But instead of doing local account i used the <sid>adm and it worked out fine. It was little tricky since it happened to me during installation. As the installation tries to restart i had to change the windows services logon to these services within the retry period and it worked out.

Thanks for the information.

RT