DTW it cannot show the company databases

[Former Member]

Can any please say some possible reasons of the following case u2013

>> We have a Windows 2003 Server with SP 2 + SQL Server 2005 Standard Edition with SP 2 for SAP B1 2007 B SP 0 PL 7.

>>Everything (using SBO from client sand-boxes, connection the Database engine form a remote computer, etc.) is working fine,

>>but when I try to connect the SBO company database from DTW it cannot show the company databases in its list of companies in the logon screen.

[Former Member · Accepted solution]

Connection to SBO common has failed error usually means user authorization problem. Check your B1 user license and make sure using right user name and password.

[Former Member · Accepted solution]

SBO License is proper u2013 professional licence & all licensees are assigned properly.

Another information for you (if it is helpful) u2013 in this particular I could not use the SBO Installation / Upgradation wizard u2026 I had to go into each and every folder then install / upgrade each and every components by the relevent setup.exesu2026

[Former Member · Accepted solution]

That is a clear sign of unclean install. You must have some old version application still running. Check it out. Your problem is definitely related to that.

[Former Member · Accepted solution]

I have ckecked that the concerned DTW can connect and list all SBO companies of any other SBO DB Server having same SQL Server as in the concerned SBO DB Server. Hence, is it not clear that the the DTW has been installed and working properly?

Edited by: Narottam Das on Jan 9, 2009 10:15 AM

[Former Member · Accepted solution]

It is not regarding your DTW clean install or not. The problem associates with the wrong installation your mentioned. You have to use integrated install, manual install is always troublesome.

[Former Member · Accepted solution]

hi Narottam Das

Try to Reinstall same patch level which is currenty used in server and restart.

by

kart

[Former Member · Accepted solution]

Its found by one of my friend that ... clear installation of SQL Server and SAP B1 solves the problem...

Edited by: Narottam Das on Feb 16, 2009 2:05 PM

[Former Member]

Have you used Windows authorization or not?

[Former Member]

SQL Server is in mixed mode but I havenu2019t windows authentication. As per my last response it is clear that I am using SQL Server authentication.

[Former Member]

There are separate check boxes for both options. You can check by windows authorization and log in to db at same time.

[Former Member]

I have checked by SQL Server Management Studio that both the authentication working properly (windows authentication is just now configured by me now and restarted the SQL server).

But if I use windows authentication in DTW then an error - "Connection to SBO common has failed" is coming. On the other hand, SQL authentication does not give any error massage but does not populate any database.

For your kind information u2013 meanwhile this response I have re-setup both the DI API and the DTW which comes with SBO 2007 B SP 0 PL 7... Nevertheless its not working.

[Former Member]

Have you checked option and Choose DB types?

Thanks,

Gordon

[Former Member]

Yes in DTW Login window I have chosen Login to Options >> Login toDB -> DB Type : SQL Server 2005 -> DB User : sa -> Password :

[Former Member]

How did you installed your DI API? It sounds that is not working properly.

[Former Member]

I have installed DI API by SDK installation which comes with the SBO installation and up gradation packageu2026 and I have checked he DI Server is also running.

[Former Member]

Check this SAP Note: 629046 Not all Databases appear in the drop down menu in the DTW

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=629046]

[Former Member]

Ok... thanks ... fine .. I will check.

[Former Member]

I could not find the Obscommon in the security -> login in sql enterprise manger of SQL server 2005 Standard Editionu2026 please help.