Skip to Content
0
Former Member
Aug 24, 2010 at 04:31 AM

Integration solution for SAP Business One - JDBC failed test connection

535 Views

Dear Expert,

i made a test connection in SLD for JDBC test connection, but i have an error mesage:

com.sap.b1i.xcellerator.XcelleratorException: XCE001 
Nested exception: java.lang.Exception: 
com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: 
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'.

Below are my JDBC setting:

driver -> com.microsoft.sqlserver.jdbc.SQLServerDriver
url -> jdbc:sqlserver://SAP2:1433;integratedSecurity=false;databaseName=B1_LIVE
username -> sa
password -> sa

username and password are correct, i can login into my database using that.

also I have successfully test connection in SLD for B1DI

thanks for help,

Honggo