Display the database

[Former Member]

Dear All,

we need to display the database in all SAP B1 running activity. Need advice. Thanks in advance

B'Regards,

Andres

[Former Member · Accepted solution]

Andres,

Have you tried click on refresh button? If the databases are active, they should be displayed automatically.

Thanks,

Gordon

[Former Member · Accepted solution]

Dear Gordon,

Tku for answer. I manage to resolve this issue.

B'Rgds,

Andres

[Former Member]

Thx All. I manage to resolve this problem.

B'Rgds,

Andres

[Former Member]

Hi All,

Thx for reply. Actually we want to display the databases in the DTW and also in the choose company window. The DTW issue have been solved but in the choose company still discovered by us but we need advice. TIA

B'REgards,

Andres

[former_member186095]

if you want to display the database in the drop down menu of DTW, here is the solution:

Not all Databases appear in the drop down menu in the DTW
Symptom
The Data Transfer workbench does not recognize the company Database when a Company Database from a given SQL server is attached to the current SQL Server. The Data Transfer Workbench cannot find this Database even though they appear in the Business One ' choose company' window.
Other terms
Datatransfer workbench, DTW, Data Migration, Database, company databaseSQL Server, SAP Business One, SBO, B1, SAP Business One
Reason and Prerequisites
The Obscommon does not exist or is missing so permission to the databaseor its permissions are not recognized.
Solution
In order to solve your problem please perform the following:
   1. Go to Start/Programs/MSSQL server/ enterprise Manager.
   2. In the enterprise manager, expand the Microsoft SQL Servers/ SQL Server group/ and then your server by pressing on the .plus. button by the icon.
   3. Click on security then logins.
   4. Doubleclick on .Obscommon. and then "Database access" tab.
   5. Click on your Company database and check if under the 'Permit in Database Role' "Public". and "db_owner" are checked.
   6. If they are not or one is missing, please go to Databases.
   7. Click on your company database.
   8. Doubleclick on users,
   9. Doubleclick on Obscommon and check if "Public" and "db_owner" are checked.
  10. Delete the User Obscommon.
  11. Right click in the user window and select "create new database user".
  12. In the pop-up window in the login name field select Obscommon.
  13. Check "Public" and "db_owner" and Press Ok.
  14. Open your Data Transfer Workbench. Select your server and click on the "Refresh" button.

but we need more detail from you. Is the DTW one of the activities ? what does it means activity here ?

Rgds,

[former_member583013]

Andres

Your question is not clear.......Please explain in detail