db_connect error, WPs die

[Former Member]

Hi,

I was trying to migrate a local installation to domain installation. But, it wasn't good. I tred to go back to local installation again, now I am having problem which WPs are dying when DB connect.

I tried r3trans -d, it shows errors. SAP is not connecting to DB correctly. Do you have any idea?

This is a part of wp log.

C ParamStmtExec: line 23949. hr: 0x80040e37 Invalid object name 'SVERS'.

C HandleOledbError [ParamStmtExec,line 23949]: Error/Message: (err 208, sev 16), Invalid object name 'SVERS'.

C ParamStmtExec failed. HR 80040e37 DBSL retcode 103. stmt: [SELECT VERSION AS c FROM SVERS ]

C Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum:12157

C DbSlRead - Error 103 (dbcode 208) on open

C DbSlRead - <##Y2KR3QA1q0100000035160000000001105906>

C DbSlRead - Error 103 (dbcode 208) on fetch

C DbSlRead - <##Y2KR3QA1q0100000035160000000001105906>

B ***LOG BZA=> table SVERS does not exist on database [dblink#1 @ 1292] [dblink 1292 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 004096) [thxxhead.c 1198]

M in_ThErrHandle: 1

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

M

Thanks.

[Former Member]

Hi,

I solved the problem. I think all of the objects in the db might have been changed. I had to change the objects ownership. The SAP notes are very helpful. Thanks for your replies.

[antonio_voce]

Hi ,

what step have you followed to migrate ?

[Former Member]

I created domain users for SAP, sidadm, SAPServiceSID, SAP_Global_Admin group, and add these domain users to MSSQL DB users, and add ENV. variables.

but the same db connection error occured.

Is there any particular steps for changing local to domain installation?

[Former Member]

Hi,

You can give a look at the following Notes might be helpful if you have created proper domain users OS.

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

SAPNote 799058 - Setting Up Microsoft SQL Server 2005

Do reward points if the message is helpful

Regards,

Suhas

[antonio_voce]

Hi ,

sorry for the late .

Follow the instruction give you by Suhas Ajgaonkar.

First you can try to change the user that start the SQL and SAP windows operating system services , with the correct user localdomain\sapservice<SID>.

Antonio