OBSCommon and BWUser Logins Deleted

[Former Member]

We have been using the licensed version of SAPBO for a few weeks when one guy in our office realized he still had the demo installed on his machine. When he went to remove the demo, it apparently removed the OBSCommon and BWUser logins from SQL Server. Now the licensed version (2004A) cannot access the databases. Aside from restoring the server, is there an easy way to restore the accounts or have SAPBO re-create the accounts it needs?

Thanks.

Mark

[AlexGrebennikov · Accepted solution]

Hi Mark!

your "one guy" seems to be very funny!

according to SAPNote 594954 you should:

Do not remove the Obscommon user!

Do not change the Obscommon password!

Do not change the Obscommon permissions!

i suppose you should create message at SAPPortal, support consultants maybe give you some SQL-scripts to re-create users you've killed..

BTW: SAPNotes 694413, 693016, 629046 provide you the method of Obscommon creation. But there is no info about BWUser.. 😕

HTH

[Former Member · Accepted solution]

I know you are thinking that "one guy" was me. Honestly, it was not. >:/

I'll try posting at the SAPPortal and see what kind of response I get.

Thanks for the help!

Mark

[Former Member · Accepted solution]

Hey Mark,

You can try executing these accounts against your SQL server database.

1) sp_change_users_login 'REPORT'

2) sp_change_users_login 'UPDATE_ONE', OBSCommon, OBSCommon

[Former Member · Accepted solution]

Sorry my post got cut off.

1. 1 will tell you any users that are in that database that no longer have a valid login. WHich has happened to us when we do a database restore.

If # 1 reports any users (bwuser, OBSCommon) then use # 2 to re link that user with its login account.

Let me know if this helps. Of course if the users no longer exist in the database these will not help you

[Former Member · Accepted solution]

Not only do the users no longer exist in the database, but their server logins no longer exist.

Thanks anyway.

Mark