on 2005 Jul 29 9:02 AM
Hi Guys
We've restored a company database but when we try to connect to it from within SAP BO we get the following error - [-1102] Encountered .We really need to connect to it, any ideas whats wrong?
Thanks
Request clarification before answering.
Hello Avish,
If you can not connect from DI API, you should check SAP NOTE: 694413.
While restoring a database from a backup, the user's definition is not
restored properly.
The DI API uses a default user: OBSCommon.
You need to fix this user in order to work with the DI API.
The fix is made by deleting the user definition and creating it again.
Please do the following:
1. Open Microsoft SQL Enterprise Manager.
2. Go to you company DB users folder e.g. Databases -> My_Company -> Users)
3. Click the OBSCommon user (so it will be marked in blue).
4. Right click it and choose -> Delete (this will delete the user).
5. Right click anywhere on the screen and choose -> New Database User.
6. In the Login Name drop down menu choose -> OBSCommon user.
7. In Database Role Membership list (below) check the 'db_owner' box (eventually public and db_owner boxes are both checked).
8. Click the OK button.
Now your OBSCommon user is defined properly.
HTH
Zsolt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go Administartion->License->License Administartion and assign the Pro User Licence to the user you want to connect with
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
39 | |
8 | |
6 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.