Database <SID> contains user objects belonging to system user dbo

[Former Member]

Hi,

I started a Java AddIn installation for NetWeaver 2004.

ABAP stack is on SP12.

Win2003 Server SP2

MS SQL 2005

SAPInst is stopping with error <b>Database <SID> contains user objects belonging to system user dbo</b>.

I can't find anything in the log files or in SMP that is guiding me into the right direction...

Any hints??

Thx,

Michael

[Former Member · Accepted solution]

Hi Michael,

You can use the stored procedure sp_check_sap_login to check and verify your db-logins as per note # 610640 .

Afterwards you can use the script "user_change.sql" which is included in the attachment of note # 551915 to change the objects from 'dbo' to 'sid'.

This may help narrow down the cause at least hopefully.

Regards, Mark

[Former Member · Accepted solution]

Hi Mark,

I have not been able to download the attachments from the notes but they look like being exactly the solution!

Thx,

Michael