Skip to Content
author's profile photo Former Member
Former Member

Test-Connection Errors in B1iF-SLD (Multiple SQL-Instances)

Hello Community

First of all i describe my situation:

My company has a fully functional SAP Business One 8.81 PL11 installation. Additionally we installed the Integration Framework (v. 1.10) to this Business One installation.

We d'like to work with it, but if i try to access the companies out of B1iF i allways got errors 😔

Now, how does our environment looks like?

Basicly everything is installed on the same physically server!

Our Business One-Environment:

B1-Server: MyServer

Licence-Server: MyServer:30000

Our SQL-Environment:

MS SQL Server 2008 -> MyServer/MSSQL (default instance) = Company Databases

MS SQL Server 2008 R2 -> MyServer/MSSQLTEST (second instance) = Test Databases

Both on the same server!

Our B1iF-Installation:

Installation: MyServer

SQL Server: B1iF database is located in the default instance

How does my SLD looks like?

System: MyCompany


Key Value b1Server

MyServer

licenseServer MyServer:30000 company

MyCompany

dbType Microsoft SQL Server 2008 dbUser sa dbPassword sa12345 userName B1i password b1if language German isTrust

false

jcoPath C:\Program Files (x86)\SAP\SAP Business One DI API\JCO\LIB diProxyhost MyServer diProxyport 2099 proxyHost - proxyPort -

Key
Value driver com.microsoft.sqlserver.jdbc.SQLServerDriver url jdbc:sqlserver://MyServer:1433;databaseName=MyCompany; username sa password sa12345


Result: WORKS

System: SBODemoCH

Key Value b1Server

MyServer

licenseServer MyServer:30000 company

SBODemoCH

dbType Microsoft SQL Server 2008 dbUser sa dbPassword sa12345 userName B1i password b1if language German isTrust

false

jcoPath C:\Program Files (x86)\SAP\SAP Business One DI API\JCO\LIB diProxyhost MyServer diProxyport 2099 proxyHost - proxyPort -

Key
Value driver com.microsoft.sqlserver.jdbc.SQLServerDriver url jdbc:sqlserver://MyServer:1433;instanceName=MSSQLTEST;databaseName=SBODemoCH; username sa password sa12345


Result: FAILED

Now i am confused. Here, i got these errors 😔

Business One DI Connection-Test

com.sap.b1i.adapter.dia.exception.ConnectionFailedException: Connect to Business One failed.

(-111) Unable to access SBO-Common database

{b1Server=MyServer/MSSQLTEST, company=SBODemoCH, licenseServer=MyServer:30000, dbType=6, dbUser=sa, userName=B1i}

JDBC Connection-Test


com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: java.lang.Exception: com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "SBODemoCH" requested by the login. The login failed.

The first error is cause it does not find a SBO-Common database but there is one :S Hmmm...?`

The second error is cause it can't login.. but the credentials are correct!

Does someone else also works with different sql-instances?

Does someone know something that could help me?

Thanks for helping me!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2012 at 01:25 PM

    I found somthing that helped me! Check out this article on msdn

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    If the SQL Server Browser service is running, you don't need to specify the port.

    SQL Server allows for the installation of multiple database instances per server. Each instance is identified by a specific name. To connect to a named instance of SQL Server, you can either specify the port number of the named instance (preferred), or you can specify the instance name as a JDBC URL property or a datasource property. If no instance name or port number property is specified, a connection to the default instance is created. See the following examples:

    To use a port number, do the following:

    jdbc:sqlserver://localhost:1433;integratedSecurity=true;<more properties as required>;

    To use a JDBC URL property, do the following:

    jdbc:sqlserver://localhost;instanceName=instance1;integratedSecurity=true;<more properties as required>;

    http://msdn.microsoft.com/en-us/library/ms378428.aspx

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    I simply removed the database port of my JDBC Connection-URL and the JDBC connection works nicely 😀

    Additionally to work with the b1 company i had to change the b1Server value to MyServer\MSSQLTEST and it also worked !

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.