Unable to access SBO-Common database

[Former Member]

Dear experts,

I have this problem.

I'm not able to connect to the sbo-common db, using web service (SAP B1 8.8 SP00 PL10 and B1WS webservice 1.1).

I used, in version 2007 of SAP B1, my own web service that calling the method "LoginService.login" of B1WS webservice, was able to access to the SAP BO database.

Now using SAP B1 8.8 and B1WS webservice 1.1, it doesn't work.

This is the error:

System.Web.Services.Protocols.SoapException: Unable to access SBO-Common database
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at SapBridgeWS.LoginWS.LoginService.Login(String DatabaseServer, String DatabaseName, LoginDatabaseType DatabaseType, Boolean DatabaseTypeSpecified, String DatabaseUserName, String DatabasePassword, String CompanyUsername, String CompanyPassword, LoginLanguage Language, Boolean LanguageSpecified, String LicenseServer) in C:\Sviluppo\Ecos_e-one\SBO-integrazione\B1WSbridge\Web References\LoginWS\Reference.cs:line 95
   at SapBridgeWS.Service1.Login(String dbServer, String dbName, LoginDatabaseType dbType, String dbUser, String dbPswd, String companyUser, String companyPswd, String licenseServer) in C:\Sviluppo\Ecos_e-one\SBO-integrazione\B1WSbridge\Service1.asmx.cs:line 317
   at SapBridgeWS.Service1.LoginCompany(String dbName, String companyUser, String companyPswd) in C:\Sviluppo\Ecos_e-one\SBO-integrazione\B1WSbridge\Service1.asmx.cs:line 307

Can you help me?

Thanks.

Paolo

[Former Member]

Ok, solved.

The problem was that login method changed. Now you don't need to provide user "sa" and password to login method.

Login B1WS 2007:

sessionId = B1Login.Login(DatabaseServer, DatabaseName, 
                            DataBaseType, true,
                             DatabaseUserName, DatabasePassword,  //THIS LINE NOT IN 8.8
                            CompanyUserName, CompanyPassword,
                            ITOPWSLogin.B1LoginService.LoginLanguage.ln_Spanish,
                            true,
                            LicenseServer);

Login B1WS 8.8:

loginServ.Login(DatabaseServer, DatabaseName, 
                        DataBaseType,  true, 
                        //NOT SA AND PASSWORD
                        CompanyUserName, CompanyPassword,
                        ITOPWSLogin.B1LoginService.LoginLanguage.ln_Spanish,
                        true,
                        LicenseServer);

[Former Member]

Hi all,

We've exactly the same problem.

Regards

[Former Member]

Solved

[Former Member]

Hi Paolo,

i'm getting the same error. How did you solve it?

Thanks in advance.

[Former Member]

Hi Paolo,

I also have same error, so please share your experience to us also.

thanks,

Bikram